Setting the Update Record dialog box options The purpose of this dialog box is to add a server behavior to a page containing an HTML form so that users can update a record in a database table when they click the Submit button on the form.
Before starting, you must complete the following tasks:
You must build one or more pages that let the user find the record they want
to update. For more information, see Identifying the record to update.
You must add logic to the update page allowing it to retrieve the user’s
chosen record from the database in preparation for updating. For instructions,
see Retrieving the record to update.
You must add an HTML form to the update page to let users modify the data. For
instructions, see Completing the update page block by block.
With these prerequisites in place, you can complete the Update Record dialog
box.
Procedure
In the Connection pop-up menu, select a connection to the database containing
the stored procedure.
Click the Define button if you need to define a connection.
In the Table to Update pop-up menu, select the database table that contains
the record you are updating.
In the Select Record From pop-up menu, specify the recordset that contains the
record displayed in the HTML form.
In the Unique Key Column pop-up menus, select a key column (usually the record
ID column) to identify the record in the database table.
Select the Numeric option if the value is a number. A key column usually accepts
only numeric values, but sometimes it accepts text values.
In the After Updating, Go To text box, enter the page to open after the record
has been updated in the table.
In the Get Values From pop-up menu, choose the HTML form used to edit the record
data.
automatically chooses the first form on your page.
Specify a database column to update, choose the form object that will update
the column from the Value pop-up menu, and then choose a data type for the form
object from the Submit As pop-up menu.
The data type is the kind of data the column in your database table is expecting
(text, numeric, Boolean checkbox values).
Repeat the procedure for each form object in your form.
Click OK.
adds a server behavior to the page that lets users update records in a database
table by modifying the information displayed in the HTML form and clicking the
Submit button.
1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 422