PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → WB22 - Data Source Search
WB22 - Data Source Search
Débuté par André Labuschagné, 17 juil. 2018 11:49 - 6 réponses
#1
Posté le 17 juillet 2018 - 11:49
Hi All

Is there anyway that a data source can be searched for a value on a field without having to loop thought the data source?

Cheers
André
#2
Posté le 17 juillet 2018 - 12:12
Of course: queries !

Cheers,

DD
#3
Posté le 17 juillet 2018 - 13:14
Hi André

easily

lets says that your data source is a query. you can do a hreadseek (or anyhting else hxxxx) on any of the fields of your query, as your datasource, once initialized, is the same as any other file of your db.

Best regards
#4
Posté le 18 juillet 2018 - 15:08
Hi Fabrice

The data source is not a query. It is filled programmatically using HExecuteSQLQuery. I seem to get an error using any of the H commands on that.

Cheers
André
#5
Posté le 18 juillet 2018 - 22:08
Hi Andre

Did you do a HReadFirst after running your HExecuteSQLQuery?

Then do your search.

Also you did test that your HExecuteSQLQuery did not fail?

Regards


Ericus Steyn
#6
Posté le 19 juillet 2018 - 00:19
Hi Ericus

There are records - the execute did not fail.

Nope - will try that.

Cheers
André
#7
Posté le 19 juillet 2018 - 09:54
André,

If that doesn't work, show us some code; it might help us to understand...
→ Revenir à WINDEV 2024