PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV Mobile 22 → [WM23] HExecuteProcedure
[WM23] HExecuteProcedure
Started by Jose, Jul., 12 2018 6:35 PM - 1 reply
Registered member
154 messages
Posted on July, 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
Registered member
154 messages
Posted on July, 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