>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)}")
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.