What could make TABLEUPDATE() fail, with ODBC reporting the following error messages? The rows I'm trying to update are basically copies of rows retrieved from the same table (with new primary and foreign keys substituted). I can provide more info about the connection and cursor properties if needed.
*-
SELECT v_LineItems && remote view into SQL Server 7 tables
CURSORSETPROP("Buffering", 5)
ll_Success = TABLEUPDATE(1)
AERROR(la_Errors)
la_Errors
[1,1] N 1526 && it's an ODBC error
[1,2] C "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server] Arithmetic overflow error converting numeric to data type varchar."
[1,3] C [Microsoft][ODBC SQL Server Driver][SQL Server] Arithmetic overflow error converting numeric to data type varchar."
[1,4] C "22003"
[1,5] N 8115
[1,6] N 2
[1,7] C
[2,1] N 1526
[2,2] C "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server] Arithmetic overflow error converting numeric to data type varchar."
[2,3] C [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated."
[2,4] C "01000"
[2,5] N 3621
[2,6] N 2
[2,7] C
- Bruce Allen
- Left Brain Incorporated
"Problems cannot be solved at the same level of awareness that created them." - Albert Einstein
Bruce Allen
NTX Data