 |
|
Deleting the record from the database table
The final step is to add the Delete Record server behavior. When the user clicks the Submit button, the Delete Record server behavior deletes the specified record from the database table.
To add a server behavior to delete the record from the database table:
| 1 |
In the Server Behaviors panel (Window > Server Behaviors), click the plus (+) button and choose Delete Record from the pop-up menu. |
|
The Delete Record dialog box appears. |
|
|
|
|
|
|
|
|
|
|
| 2 |
Use the Connection and Delete From Table pop-up menus to specify the database table containing the records to be deleted. |
| 3 |
In the Select Record From pop-up menu, specify the recordset that contains the record to be deleted. |
| 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 Deleting, Go To text box, enter the page to open after the record has been deleted from the database table. This is usually a page informing the user that the record has been deleted. |
| 6 |
In the Delete By Submitting pop-up menu, specify the HTML form with the Submit button that sends the delete command to the server. |
| 7 |
Click OK. |
|
|
Your delete page is now ready to delete a record from your database.
|
|
|
|
