Accessibility
 
Home > Products > UltraDev > Support > Editing Database Records
Dreamweaver UltraDev Icon Macromedia Dreamweaver UltraDev Support Center - Editing Database Records
Updating records in Dreamweaver UltraDev 4

Your application can contain a page that lets users update existing records in a database table.

An update page has three building blocks:

A filtered recordset to retrieve the record from a database table
An HTML form to let users modify the record's data
An Update Record server behavior to update the database table

You can add the HTML form and the server behavior to the page in a single operation using the Record Update Form live object, or you can add them separately using the Dreamweaver form tools and the Server Behaviors panel. For instructions on the latter, see Building an update page block by block.

The search results page may serve as an update page if it displays a single record. This article describes how to construct a single-record search update page. The user will search for an employee by last name, and then update that employee's information in the database.

If you want your results page to list more than one record from your database (several employees named Smith, for example), you can create a list of results on the page, then add a Go to Detail Page server behavior that names the detail page as the update page. For instructions on creating this kind of results page, see Building a simple database search feature. For instructions on creating a detail/update page, see "Creating a detail page for a results page," and "Building a page to update records" in Using UltraDev.

Note: The update page can contain only one record-editing server behavior at a time. For example, you cannot add an Insert Record or a Delete Record server behavior to the update page.

To Table of Contents Forward to next document