PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WINDEV Mobile 22 → [WM23] HExecuteProcedure
[WM23] HExecuteProcedure
Iniciado por Jose, jul., 12 2018 6:35 PM - 1 resposta
Membro registado
154 mensagems
Publicado em julho, 12 2018 - 6:35 PM
Hi

I was wondering about to execute a stored Procedure but this are going to return a Data Source, when I try to read this data source WM said that this data source wasn't declare.

In the end I conclude that the data it's delete it when it's return to the app.

So there's a way to return a data source and can be use it on my app?

Here's some code

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


My server:
HExecuteQuery(QRY_QueryTestProcedure)
RESULT QRY_QueryTestProcedure


or

resp is Data Source
HExecuteSQLQuery(resp,hQueryWithoutHFCorrection,"Select * From Table_Test")
RESULT resp


Thanks.

--
Best Regards
Jose
Membro registado
154 mensagems
Publicado em julho, 13 2018 - 9:52 PM
Hi

Let me re-write the question.

I know that the procedure return a variant, but If I execute a query and I have a total of 10 data, is it possible to send the 10 of them to my app?

Like using a for each of my query and then using a Result on my procedure to my app. is it possible?

--
Best Regards
Jose