Row cannot be located for updating. Some values may have been changed since it was last read in sql server.?
470062
Sounds like your table lacks a primary key.\n\nIf it does have a primary key, you should check the lock you are using; you're probably using an optimistic lock on a database that others are updating, while you really need to use a pessimistic lock on the records you want to modify.
112568
refer these urls..\n\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_5b1v.asp\n\njust surf through the bookmark on left hand side..\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_30s5.asp\n\n\nalso refer this one..simple n straight forward\nhttp://www.1keydata.com/sql/sql-create-index.html
390196
It means that website has problems with its database. The only solution is to try again later.
192852
call service provider they may have it save in there database(MOST LIKLY) and they can fix your problem to.\n\nBacon out!
1133054
You probably have the view type in windows explorer on 'list'. First, change it to 'details', by typing 'alt+v' and choose 'details'. Then click 'Date Modified' column header on the right.
700974
Try changing your field Password to something like pass. Password is a key word in SQL and therefore your update statement will not work. Give it a try and let me know if it works.\n\nHope this helps
714857
It is mysql_num_rows... you forgot the second underscore. Secondly your elseif could probably be written as an else or if you are testing for null being false or not, just test against true and false. \n\nI can't say too much more about the elseif since I don't know what context this snippet is in, but I know it can be a bit cleaner.\n\nTry the change of mysql_num_rows and see what happens.\n\nHope it works for you!
335757
Can you post any of the code you are trying to do? Im not sure I understand completely what you are trying to accomplish. So you have 266 records in a table and you are trying to do an update on any given record? What is the SQL you are trying to run to do it?\n\nAssuming you have an id field for the 266 records, you just need to do something like "update tablename set field1 = 'blah', field2 = 'somethingelse' where id = #ofidfield". I am assuming you have the html form set up so that the submit page has the uddate query that will probably need the ID field # passed in as a form variable or passed on the URL.\n\nSo when you are outputting the detail records, are you looping through the recordset to create the update link that goes to the update page? So that every detail record has a link to update some information and that link has a distinct ID in it? And have you output the ID you are trying to use before the SQL update query is run to make sure you are using the right value? I guess what I am getting at is it the update query itself that isnt working or are you not getting the right value to that query (but it actually works even though not updating the right record).\n\nSo two things to check. Have you verified that the 32 is actually being passed in the URL? Then have you checked the update statement to make sure it is using that URL variable in the where clause so it knows what record to update? Also, are you on classic asp or aspx?
168991
I am assuming you are the one asking the questions.  I have found that the biggest failing database developers have is not using the resources available for code samples. \n\nQ:  Where would you turn for help with creating a stored procedure or a select statement that was erroring out?
948329
It sounds like you are using a linked table that does not have a primary key. Without a primary key, I think Access looses track of which row is which, and gets this error. Even if you don't want to use a primary key, you could add a primary key column to the backend table (for example, with an auto-increment value) just for Access to use. Then you can leave that column out of your queries in Access.
1045597
you must get current value of row spli it with ', ' and insert 2 section or more of rows another time to table .therefore need to 3 functon :\nget - split - update(or insert)
331235
You can reset the autonumber field for an existing table by truncating the table. SQL to do so:\n\nTRUNCATE TABLE tablename\n\nThis destroys all data in the table, so be careful!\n\nYou can create a table in SQL and specify the initial seed value:\n\nCREATE TABLE [tablename] (\n[column0] [number] NOT NULL IDENTITY (100, 1) PRIMARY KEY,\n[column1] [text] NOT NULL,\n[column2] [date] NULL\n)\n\nYou can later change the current index of the autonumber column using ADO:\n\nhttp://allenbrowne.com/ser-26.html
390872
I don't know if 125 is past the point of no return or not (it does seem like an *unusually* high number of fields to update in a single web page).\n\nBut I'm wondering, are you getting any sort of error message other than the eventual timeout? \n\nAnd if not, do you have an "on error resume next" statement in your code? Because if you do, I'd suggest commenting that out to see if your update is actually failing due to some other reason (125 fields could leave a lot of room for data validation errors to slip through).
1124246
1) Consider adding another field that records last date when the record was changed or a record version number so that you have a single field to test against.\n\n2) Then (depending on technology - is this Oracle, SQL, Access???) look at what sort of indexing you have set up.  This can dramatically speed up performance.
1123805
A data adapter has to be set up to actually update data. You need to either use a CommandBuilder and give the DataAdapter its GetUpdateCommand() method to its .UpdateCommand property, or you have to write the SQL for the UpdateCommand yourself.\n\nThe fact that it is not saving for you either way should be your clue that the problem is with your saving procedure, and not the exit event.
641885
give more information. like which query causes the error ? what is the data being passed ? What is the Sequence of statement before the query is called? give the code?
986913
This may be because of some changed settings, check where the settings are stored. normally it will be in c:/documents and settings/yourusername/application data