? 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 -1FYI, at run time, the 2nd parameter of SQLEXEC (as above) is passed as a variable to a method that calls SQLEXEC(). However, the above code does not run from the command window so, I still seem to be doing something wrong.
>>PRIVATE nOutVal >>nOutVal = .NULL. >> >>SQLEXEC(4, "{CALL nOutVal = Claim.dbo.RepairSP_UpdateRepairOrder 261657,5002,'',NULL,NULL}") >>>>