Setting the Record Update Form dialog box options The purpose of this dialog box is to build a page that lets users update records in a database.
Procedure
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.
With these prerequisites in place, you can complete the dialog box as follows:
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 to update.
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 menu, select a key column (usually the record
ID column) to identify the record in the database table.
If the value is a number, select the Numeric option. 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
updates in the table.
In the Form Fields area, specify which columns in your database table each form
object should update.
By default, creates a form object for each column in the database
table. If your database automatically generates unique key IDs for each new
record created, remove the form object corresponding to the key column by selecting
it in the list and clicking the minus (-) button. This eliminates the risk that
the user of the form will enter an ID value that already exists.
You can also change the order of the form objects on the HTML form by selecting a form object in the list and clicking the up or down arrow on the right side of the dialog box.
Specify how each data-entry field should appear on the HTML form by clicking
a row in the Form Fields table and entering the following information in the
boxes below the table:
In the Label box, enter a descriptive label to display beside the data-entry
field. By default, displays the table column’s name in the
label.
In the Display As pop-up menu, choose a form object to serve as the data-entry
field. You can choose Text Field, Text Area, Menu, Checkbox, Radio Group, and
Text. For read-only entries, choose Text. You can also choose Password Field,
File Field, and Hidden Field.
Note: Hidden fields are inserted at the end of the form.
In the Submit As pop-up menu, choose the data format expected by your database
table. For example, if the table column only accepts numeric data, choose Numeric.
Set the form object’s properties. You have different options depending
on the form object you choose as your data-entry field. For text fields, text
areas, and text, you can enter an initial value. For menus and radio groups,
you open another dialog box to set the properties. For checkboxes, select the
Checked or Unchecked option.
Set the properties of other form objects by selecting another Form Fields row
and entering a label, display as value, and submit as value.
For menus and radio groups, open another dialog box to set the properties. For
checkboxes, define a comparison between the current record’s value for
the checkbox and a given value to determine whether the checkbox is checked
or not when the record is displayed.
Click OK.
adds both an HTML form and an Update Record server behavior to your
page.
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