ADMINISTRATION - Update a record behavior (Updating Records)

Just to make things quicker I’m going to re-use the form from the "insertrecord.asp" page. Open up the file "updaterecorddetails.asp" that you created on the previous page. Create the form however you like, if you want you can copy and paste it from the insert record page.

Tip: If you copy and paste, be sure to remove any Server Behaviors the form might have attached to it. We don’t want to confuse UltraDev once you paste it into your new page J

Create a new connection under Window > Data Bindings. This time set the Filter to ID=(Url Parameter)ID. Select the first name form field on the page, then go back to the Data Bindings window and select from the list "first" and press the Bind button.

You should now see text inside the form field itself on the page, binding it to the "first" field in the database.

Do this for every form field on the page coordinating it with the fields in the database. After you are done with that open Window > Server Behaviors and from the + sign select Update Record from the menu. It will bring up a new dialog window where you will select the connection and table as usual.

This time since you bould all the fields to the form fields, you don’t have to match up the Form Elements with the Columns. So just hit OK, and you should be able to test it out!