Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some questions about SQL server 2000/ VFP 7.0
Message
 
To
02/10/2002 02:53:38
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00706710
Message ID:
00706779
Views:
20
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform