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
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe