PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WEBDEV 2024 → [WB23] Question about HExecuteProcedure
[WB23] Question about HExecuteProcedure
Débuté par ARV, 10 juil. 2018 19:08 - 1 réponse
#1
Membre enregistré
498 messages
Popularité : +8 (8 votes)
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
#2
Membre enregistré
498 messages
Popularité : +8 (8 votes)
Posté le 12 juillet 2018 - 18:27
Hi

any ideas?

--
Best Regards
Jose
→ Revenir à WEBDEV 2024