PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WEBDEV 23 → [WB23] Question about HExecuteProcedure
[WB23] Question about HExecuteProcedure
Iniciado por ARV, jul., 10 2018 7:08 PM - 1 resposta
Membro registado
256 mensagems
Publicado em julho, 10 2018 - 7:08 PM
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
Membro registado
256 mensagems
Publicado em julho, 12 2018 - 6:27 PM
Hi

any ideas?

--
Best Regards
Jose