If you are trying to pass parameters back rather than a cursor you need to use the 'CALL' syntax.

stringvar=' '
iRetVal=0
iResult=SQLEXEC(ConnectionHandle,'{CALL StoredProc (?stringvar, ?@iRetval)}')

This is passing 2 variables to the stored procedure and the second variable (iRetVal) is returned. This variable within the stored procedure must be an 'Out' type variable.

HTH,
George

---

>HI ALL
>
>Can anyone please tell me how to called a stored procedure from sql 6.5 server from VFP?
>
>
>Thanks
>Fida