PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español FR
Inicio → WINDEV 2024 → WB22 - Data Source Search
WB22 - Data Source Search
Iniciado por André Labuschagné, 17,jul. 2018 11:49 - 6 respuestas
#1
Publicado el 17,julio 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
Publicado el 17,julio 2018 - 12:12
Of course: queries !

Cheers,

DD
#3
Publicado el 17,julio 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
Publicado el 18,julio 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
Publicado el 18,julio 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
Publicado el 19,julio 2018 - 00:19
Hi Ericus

There are records - the execute did not fail.

Nope - will try that.

Cheers
André
#7
Publicado el 19,julio 2018 - 09:54
André,

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