Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AllihKhan
Starting Member
1 Post |
 Posted - 2004-09-21 : 12:15:27
|
| Updating a non key field in a recordset with same table joined multiple times gives the following error.-2147217864"Row cannot be located for updating. Some values may have been changed since it was last read."Below is the example of the record sourceselect [TI].[DESC] AS [DESCRIPTION] from TI left join TI as TI_1 on TI.input= TI_1.keywhen you call updatebatch after updating the decs field you get the error above. Although for a similar query below everything works fine but it doesnt have the same table joined multiple timesselect [TI].[DESC] AS [DESCRIPTION] from TI left join T2 as TI_1 on TI.input= TI_1.key.Everything else is same cursortye, cursor location etc |
|
|
|
|
|
Updating recordset with same table joined multiple