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)}")
>