Vb 6 0 row cannot be located for updating
The table it tries to update has an Identity column. Post by fniles I am using VB6 connecting to a SQL Server 2005 database using ADO. Some values may have been changedsince it was last read).
This sample chapter from David Sceppa's "Programming ADO" book will help youunderstand why the error can occur: you for your reply.The table does have a primary key called [Order] a varchar(50), butthe identity column is another column called [ID], and [ID] is not theprimary key. trap the error and loop while error until say 5 times and try toupdate like the following:on error goto my Err. Update method I get the error -2147217864 (Rowcannot be located for updating.The sql statement include all columns:select * from my Table where [order] = '" & (s Order) & "'What chapter and section from David Sceppa's "Programming ADO" bookthat talks about it ? Updatemy Err: NR = 0Do While err.number = -2147217864 And NR Post by fniles I am using VB6 connecting to a SQL Server 2005 database using ADO. Some values may have been changedsince it was last read). CHM Help Context 1000440 Number -2147217864 Source 'Microsoft Cursor Engine' . Some values may have been changed since it was last read Help File C: WINDOWSHelp VBENLR98.
If you update a column that has been declared , an error occurs if strict SQL mode is enabled; otherwise, the column is set to the implicit default value for the column data type and the warning count is incremented.