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

Record Was Not Edited

 		2/5/2013 23:00:34
ASPRunnerPro General questions
H
 heets author

I have a project that was built and maintained using version 6.2 build 5482. It has been working fine until recently but now when I try to edit an existing record (not inline) I get a "Record was not Edited" message. I have made several changes in the Events section but they are all in the List category not the Edit category.
Editing seems to be working fine on one table but not on another. I haven't made any permission changes since the editing was working.
Any ideas?
G
 		gdmacdo 2/6/2013

It could be a field from a joined table that is present in your page.
Go to HTML view of the edit page, select all, copy, and paste into a notepad page (to maintain a backup of your settings). Then, click on Reset, Reset this page, and build your project. Does this make a difference? If so, you can paste the notepad contents back into the page, rebuild and compare.
H
 		heets author 2/6/2013

Thanks for your quick reply Greg Mac!
As the saying goes, great minds think alike. I tried reseting the edit page but that did not solve the problem.
At one point I did add in some code that I found on this forum that allows people to login using mixed case even though the userids are all uppercase. I though for sure this was the root of the problem but I have removed that code and rebuilt the program, same issue.
G
 		gdmacdo 2/6/2013

Can you click on your Query page tab? Are you linked to any tables/views that you may not have security? Are one of the other table/view fields on the Edit page in question?
H
 		heets author 2/6/2013

Another good thought but it is a straight Select from a single table.
G
 		gdmacdo 2/6/2013

My only other thoughts is a field size is too small or field type is invalid. Do you have any events that might be conflicting?
H
 		heets author 2/6/2013

Thanks for your ideas but the only events I have in place are specific to the list pages and they swap out versions of static text based on the language selected.
I've got some older versions of the program available, but not all of them unfortunately. I guess I will try going backwards and try to find a working version then move forward.
Any other ideas are always welcome.
G
 		gdmacdo 2/6/2013

Can you copy and paste the exact error message? Did you verify the field sizes are large enough to contain the entered text? What type of database are you using?
Sergey Kornilov admin 2/6/2013

You need to troubleshoot your application. The obvious place to start is to enable SQL debugging and to figure out what SQL query is executed. Once you get a hold of SQL query you can run it manually: http://xlinesoft.com/asprunnerpro/docs/debugging_tips.htm
Another place to check is events like BeforeEdit. If you do not return True in that event ASPRunnerPro won't be saving data to the database.
H
 		heets author 2/6/2013

Error message: <<< Record was NOT edited >>>
I am using an Access database and I am able to edit a different table within the same database from the same program. I get the same error if I upload the program to my demo account so I don't think it has anything to do with permissions on my hosting company's server. Field size checks out ok.
I will try admin's sql debugging suggestions.