Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Single row update cannot find the row (Read 2600 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Single row update cannot find the row
11.05.06 at 17:24:21
 
Single Row Update error: "Cannot find the row to update. Someone else may have changed it."
 
Nick from the UK asked the following question:
 
Question:
When updating data using the single row update feature the following error message is received:
Cannot find the row to update. Someone else may have changed it.
 
Answer:
SQL*XL may display this message when it cannot update exactly 1 row. SQL*XL will attempt to find the record in the database using all the old data fields. There are three possibilities. SQL*XL can find no rows to update or it can find too many rows to update. In these cases this message is shown. Only when precisely one row is found, SQL*XL will make the update.
 
This can happen for example when there is a date + time column. Usually dates and times are recorded to the millisecond accurate. Excel can however only show it in seconds. This truncation may lead to SQL*XL not being able to find the record in the database anymore, or to find too many of them.
 
Solutions:
It is always possible to use the multiple rows update feature of SQL*XL to update the data.
To use this feature, write an SQL statement bringing the data back  you want to update. Dump the results in Excel and start making your changes. When you are done, open the SQL*XL update multiple rows dialog. It will verify your changes and send them to the database.
This dialog uses a different technique for updates and the above mentioned problem will not occur.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1