Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Some questions about SQL server 2000/ VFP 7.0
Message
 
À
02/10/2002 02:53:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00706710
Message ID:
00706779
Vues:
22
Hi Petros:

*- Calling a SP and receiving an output parm from SP
lnKey = 0
= SQLEXEC(lnConHandle, '{call spSome_SP(?@lnKey)}')

*- Calling a SP and passing in a parm
lnSuccess = SQLEXEC(lnConHandle, '{CALL spSome_SP(parm_list)}')

*- Calling a SP and passing in a parm and receiving an output parm from SP
lcRetval = SPACE(23)
lnSuccess = SQLEXEC(lnConHandle, '{CALL spSome_SP(parm_list, ?@lcRetval)}')

*- Calling a SP and receiving a VFP cursor
= SQLEXEC(lnConHandle, '{CALL spSome_SP(parm_list)}', 'VFPcursor')

If lnSuccess is negative, you can figure out error with AERROR() for ODBC.

Look in VFP developers guide. There are good examples.

Charlie
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform