Home > Products > UltraDev > Support > Editing Database Records
Dreamweaver UltraDev Icon Macromedia Dreamweaver UltraDev Support Center - Editing Database Records
Adding the Update Record server behavior

To add the Update Record server behavior:

1 In the Server Behaviors panel (Window > Server Behaviors), click the plus (+) button and choose Update Record from the pop-up menu.
The Update Record dialog box appears.
2 Use the Connection and Table to Update pop-up menus to specify the database table containing the records to be updated.
3 In the Select Record From pop-up menu, specify the recordset that contains the record displayed in the HTML form.
4 In the Unique Key Column pop-up menu, select a key column to identify the record in the database table. Be sure that the values in this database column are unique. (In this example each last name must be unique.) If the value is a number, select the Numeric option.
5 In the "After Updating, Go To" box, enter the page to open after the record has been updated in the table.
6 In the Get Values From pop-up menu, choose the HTML form used to edit the record data.
7 Specify what each object on your form will update in the database table by selecting a form object in the Form Elements list, then choosing a table column from the Column pop-up menu and a data type from the Submit As pop-up menu.
The data type is the kind of data the column in your database table is expecting. For example, if the column in the table accepts only numeric values, choose Numeric from the Submit As pop-up menu.
The Submit As pop-up menu lists two Date data types. Choose the Date MS Access data type for Microsoft Access databases; choose the Date data type for any other type of database.
Repeat the procedure for each form object in the Form Elements list.
8 Click OK.
The form on your results/update page is now ready to update your database.

To Table of Contents Back to Previous document