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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only