PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → How to run a Stored Procedure into windev
How to run a Stored Procedure into windev
Débuté par Ricardo, 24 sep. 2008 01:57 - 1 réponse
#1
Posté le 24 septembre 2008 - 01:57
Hello, everyone,
I need to run a stored procedure into Windev, there some command to do this, someone could help me ?
thanks
Ricardo
#2
Posté le 24 septembre 2008 - 18:25
Hi Ricardo,
If you talk about a stored procedure on a HF C/S server, look at HExecuteProcedure.
If you want to execute a stored procedure in an analysis (for HF) I never was able to call them directly. -- Maybe there is a trick I don't know.
I stopped using stored triggers in the analysis when I saw it was not compatible HF and HF/CS (and other DB).
I would like that if I define a procedure in the analysis, to be usable and working in HF Classic and in HF C/S when available. This is sad this is not working. Also, stored procedure in the analysis should be available. And such trigger should also work with other DB wether native or not. (I.e. by executing the trigger locally as in HF Classic.)
But I guess I'm dreaming. That would be real DB portability.
in the meanwhile, I'm building my "own" procedure that I call manually, using transactions.
Best regards.
→ Revenir à WINDEV 2024