2. ASPRunnerPro General questions
  3. Record Was Not Edited
This topic is locked

Record Was Not Edited

 		2/19/2013 9:07:09 PM
ASPRunnerPro General questions
G
 georgeb author

getting this error

<<< Record was NOT edited >>>
Query-based update failed because the row to update could not be found.
five fields in the table with 2 records in the table

id field set as identity (sql server)

no code in the form straight from the builder

v7.2 build 14944
thoughts?

GAB
Sergey Kornilov admin 2/20/2013

My guess is that you are trying to update a SQL Server view that is not updatable. Solution - make sure this view is updatable.
Check 'Updatable Views' section at http://msdn.microsoft.com/en-us/library/ms187956.aspx
G
 		georgeb author 2/20/2013



My guess is that you are trying to update a SQL Server view that is not updatable. Solution - make sure this view is updatable.
Check 'Updatable Views' section at http://msdn.microsoft.com/en-us/library/ms187956.aspx


clarification

it's a table not a view and the record gets updated.....the form returns the error but the record is updated
Sergey Kornilov admin 2/20/2013

I guess you need to show us your database an application in this case. Not sure what else I can do without seeing your app.
Post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.