We are having trouble with this ourselves.

When we put the question mark in the sqlexec, vfp asks for a view parameter.

How do you get a sybase stored proc to return a value and/or a cursor?

How do we return the storec proc @@error variable?

TIA.

-------------------------------------------------------------------------------------------

You are a life saver as normal. What does the ? signify in transact SQL? Does it force the output to the memory variable?

Vitaliy mne skazal shto ya dolzhen skazat' 'spasibo'. Spasibo.

>Try

lcSQL = [EXEC rtSearchExactflt 1, 'CALCFACT', 'CA', 'OTHERLIAB', 'OTHER', '', ?@lnPip]
>
>
>>We have a stored procedure that returns a rating factor like 1.45, or 3.52
>>
>>This stored procedure is called from within other stored procedures on SQL 2000 and I need to get this value with a direct call to the store proc via VFP 6.0.
>>
>>Here is my code:
>>
>>
>>lnPip = 0.00
>>lcSQL = [EXEC rtSearchExactflt 1, 'CALCFACT', 'CA', 'OTHERLIAB', 'OTHER', '', @lnPip OUTPUT ]
>>lnResult = SQLEXEC(lnHandle, lcSQL)
>>
>>
>>Then I tried this at the suggestion of our DBA
>>
>>lcSQL = [EXEC rtSearchExactflt 1, 'CALCFACT', 'CA', 'OTHERLIAB', 'OTHER', '', @lnPip OUTPUT SELECT @lnPip]
>>
>>
>>No matter what I do, I can't get the return value. If I run the command from SQL Analyzer, I get the factor immediately. How do I get it from within VFP?
>>
>>Thanks in advance.