Record not updating

Report · Mar 30, 2009

I had a beautiful application working, decided to rename a few of the database fields and change the data types to decimals to enhance the app and now I cannot get a record to update on my existing update page. I have deleted the recordset and readded it (no red exclamation points), and relinked all the fields and even changed the URL parameter on the main page which the EDIT link is on. I get the correct record to display on the edit page and even the two dyamic fields are displaying the correct data however when I click to update the record, it doesn't update. Help please!

Report · Mar 31, 2009

Sometimes this happens when the datatype source and destination are
different. Since you changed some datatypes be sure that your update
uses the correct datatype. You did not say if you recoded you update
but my guess is you did not.

Report · Apr 02, 2009

On the first instance of this problem I did change the datatype from integer to decimal. Went back and changed in the Update behavior to Double so that I could see the decimal values. Still can't update records in that database but I have a new issue with a database that is strictly VARCHAR across the board.

I had the update page working which was built using the Update Record Wizard. Linked and EDIT button and that worked too. Updated records just fine. Went to change one of the fields to be a dropdown list box with the Dynamic value linked to hold the proper choice in the Update page and now I'm getting the same behavior. Record displays properly when clicking Edit, values look right, then I make a change (any change - not just a dropdown choice) and I get taken back to the original page but no update. This is very frustrating.

Steve

Report · Apr 05, 2009

I found the issue on both pages. The hidden field was not at the bottom of the form and did not have a value in it. Changed this and both pages work great. I've found that even if you do things properly and in the proper order you still have to babysit dreamweaver and look over it's shoulder because it likes to insert or in this case, not insert code.