PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Accessing Data without Analysis
Accessing Data without Analysis
Iniciado por yogiyang007, 23,jun. 2012 12:24 - 4 respuestas
Publicado el 23,junio 2012 - 12:24
While developing in WD I observed that if we want to access any data (in HFSQL) we have to first create its Analysis.

I would like to know if there is any way by which we can access HFSQL data with pure code instead of first creating analysis and then linking all controls with analysis?

TIA

Yogi Yang
Publicado el 29,junio 2012 - 08:50
Yogi,
You should be able to declare a "data source" variable then execute SQL
to return a dataset.
HExecuteSQLQuery is the call I think.
You might need to declare and initialise a data connection also.


---
Steve Hodgman

On 23/06/2012 7:24 PM, Yogi Yang wrote:
While developing in WD I observed that if we want to access any data (in HFSQL) we have to first create its Analysis.

I would like to know if there is any way by which we can access HFSQL data with pure code instead of first creating analysis and then linking all controls with analysis?

TIA

Yogi Yang
Publicado el 29,junio 2012 - 11:54
Steve Hodgman wrote in news message <4fece212@news.pcsoft.fr>:
Yogi,
You should be able to declare a "data source" variable then execute SQL
to return a dataset.
HExecuteSQLQuery is the call I think.
You might need to declare and initialise a data connection also.

Can you point me to any documentation on this please?
Publicado el 25,abril 2015 - 16:54
look at documentation for hDescribeFile()
Publicado el 28,abril 2015 - 14:19
Thanks I have been using this already.

But I have observed that if we do not use Analysis then WD does not support auto completion when coding.

Thanks once again.

Regards,

Yogi Yang