>What's return value from SQLEXEC()? If it's -1, what ODBC error AERROR() reports?
-1
1526
"Connectivity error: [Microsoft][ODBC SQL Server Driver]Numeric value out of range"
"[Microsoft][ODBC SQL Server Driver]Numeric value out of range"
>The Sp parameters list should be encloused in parenthessis.
It is now but still not working.
{?@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)}
>BTW, why're you using hardcoded ODBC connection handle?
Just to show you the value - it is using a variable in the actual code.
Thanks.
-=Gary