I am trying to Add new field values using RDO connection, Query, Resultset onto a SQL SERVER 7.0 database and get the follwoing error.
Runtime error:40002
"01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated."
When I update a row already saved in the database, it works. Only when I try to add a new row, it gives me this error when it hits the '.update' statement. I remember it was working before, I can't really figure out what I'm doing wrong. A search at MSDN website was not fruitful. Even giving me an idea about where I can get enough info to correct the error- will be very helpful. Thanks in advance!
