PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Like debeo to execute the SP?
Like debeo to execute the SP?
Débuté par Manuel, 17 sep. 2007 16:25 - Aucune réponse
#1
Posté le 17 septembre 2007 - 16:25
I need to execute a Stored Procedure in Windev XI, but when executing it the SP me must return N values that I must list in a ListBox control.


Like debeo to execute the SP?


Because single profit to rescue 1 value and not several.


I am using these commandos:

respuestaVB is boolean


sp_prueba2 is Data Source


HPrepareSQLQuery(sp_prueba2, "MyConnection", hQueryWithoutCorrection, "sp_prueba2 @variable, @res")


sp_prueba2.variable = 2


respuestaVB = HExecuteSQLQuery(sp_prueba2)


IF respuestaVB = False THEN Error(ErrorInfo(errInfo))


...

As I cross "sp_prueba2"?




Pardon by my English.

Been thankful
→ Revenir à WINDEV 2024