PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WEBDEV 22 → [WB23] Question about HExecuteProcedure
[WB23] Question about HExecuteProcedure
Débuté par Jose, 10 juil. 2018 19:08 - 1 réponse
Membre enregistré
157 messages
Posté le 10 juillet 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
Membre enregistré
157 messages
Posté le 12 juillet 2018 - 18:27
Hi

any ideas?

--
Best Regards
Jose