What's return value from SQLEXEC()? If it's -1, what ODBC error AERROR() reports?
The Sp parameters list should be encloused in parenthessis.
BTW, why're you using hardcoded ODBC connection handle?
>This is what I have :-
>
>
>? SQLEXEC(4, [{?@nOutVal=CALL Claim.dbo.RepairSP_UpdateRepairOrder
261657,5002,'',NULL,NULL,NULL,NULL,NULL,NULL,
0.000000,NULL,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'',4,
15358,NULL,NULL,NULL,1,NULL,1,NULL}])
>
>
>However, nOutVal is staying at its initialised value ie., NULL. The stored procedure being called simply accepts the above values and the first "valid" line says :-
>
>
>RETURN -1
>
>
--sb--