Setting the Form Element Properties dialog box options The purpose of this dialog box is to set properties for form elements on pages that lets users update records in a database.
Procedure
Select either Manually or From Database, depending on how you plan to create
the form element.
Click the plus (+) button to add an element.
Enter a label and value for the element.
In the Select Value Equal To text box, if you want a particular element selected
when the page opens in a browser or when a record displays in the form, enter
a value equal to the element’s value.
You can enter a static value or you can specify a dynamic value by clicking
the lightening bolt icon, then selecting a dynamic value from the list of data
sources. In either case, the value you specify should match one of the element’s
values.
Setting the Insert 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 insert records in a database table when they
click the Submit button on the form.
Before adding this server behavior, the page must contain an HTML form with a Submit button.
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 Insert Into Table pop-up menu, select the database table into which
the record should be inserted.
In the After Inserting, Go To box, enter the page to open after the record is
inserted into the table or click Browse to browse to the file.
In the Get Values From pop-up menu, choose the HTML form used to enter the data.
automatically chooses the first form on your page.
Specify a database column to insert the record in, choose the form object that
will insert the record 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 insert records
in a database table by filling out 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