Good to hear. I'll run it as soon as I get a test setup. Thanks again.
Gary


>Hi Gary,
>
>I don't know about Sybase but it certainly works with SQL Server 2000.
>
>>Hi Sergey,
>>Thanks for the tip. It *almost* works. The proc executes ok but the return value is odd. Below is what I ran and the results.
>>
>>A possible problem is that I'm running this against Sybase 12.5 instead of MS SQL Server and I've found Sybase to be a little flaky sometimes. I'll run this against MS SQL Server as soon as I can. Thanks again.
>>
>>Gary
>>
>>*-- VFP Code
>>LOCAL nRetVal
>>LOCAL cName
>>
>>nRetVal = 0
>>? SQLEXEC(nConnection,[{?@nRetVal=call test1 ?cName}]) && Returns 1
>>? nRetVal && Returns 3.92438E-308
>>
>>*-- Stripped down version of the proc and call
>>? SQLEXEC(nConnection,[{?@nRetVal=call test2}]) && Returns 1
>>? nRetVal && Returns 4.06272E-308
>>
>>***********************************
>> CREATE PROCEDURE test1
>> @cName CHAR (8)
>> AS
>> BEGIN
>> if @cName = 'Gary'
>> return 123
>> else
>> return 321
>> END
>>
>>**********************************
>>
>> CREATE PROCEDURE test2
>> AS
>> return 123
>>
>>