PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WEBDEV 23 → [WB23] Question about HExecuteProcedure
[WB23] Question about HExecuteProcedure
Iniciado por ARV, 10,jul. 2018 19:08 - 1 respuesta
Miembro registrado
226 mensajes
Publicado el 10,julio 2018 - 19:08
Hi

my question is:

Is it possible to execute a store query on a store procedure and then return it on my program on a data source?

I have some code like this:

My site:
dsTest is Data Source
dsTest = HExecuteProcedure(Connection1,ServerTest)
HReadFirst(dsTest)
Info(dsTest.ID)


Store Procedure:
HExecuteQuery(QRY_QueryTestProcedure)
RESULT QRY_QueryTestProcedure



on this code it doesn't work because it said that my query is not declare (it's obvious because the data source is erase when I call it) but I want to know if it is a way to return all the data of a store query and no only one variable or one data.

also if is it possible to only execute the store query I search but I think it is not possible at all I think...

Thanks

--
Best Regards
Jose
Miembro registrado
226 mensajes
Publicado el 12,julio 2018 - 18:27
Hi

any ideas?

--
Best Regards
Jose