Hi Borislav,
Nearly! Thanks! <s>
Best
>>Hi,
>>
>>Can anyone give me some sample syntax for getting a return value from a Stored procedure?
>>
>>I am sure that Sergey has posted similar code in the past. I am sure you need to use CALL rather than EXEC in order to get the return value. This is what I have so far and it doesn't want to play ball :-
>>
>>
>>PRIVATE nOutVal
>>nOutVal = .NULL.
>>
>>SQLEXEC(4, "{CALL nOutVal = Claim.dbo.RepairSP_UpdateRepairOrder 261657,5002,'',NULL,NULL}")
>>
>>
>>Any pointers?
>>
>>Thanks.
>
>
>nOutVal = .NULL.
>SQLEXEC(4, "{?@nOutVal = CALL Claim.dbo.RepairSP_UpdateRepairOrder(261657,5002,'',NULL,NULL)}")
>
-=Gary