Setting the Record Insertion Form dialog box options The purpose of this dialog box is to build a page that enables users to insert new records in a database.
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.
If you use ColdFusion, enter a user name and password.
In the After Inserting, Go To text box, enter the page to open after the record
is inserted into the table or click the Browse button to browse to the file.
If you use ASP.NET, you can specify a page to go to on success, and a page to
go to on failure. Or you can choose to display debugging information upon failure.
If you select Display Debugging Information on Failure, ignores
the On Failure, Go To option.
Tip: Use the Display Debugging Information on Failure option during development, and then use the On Failure, Go To option when your page is live.
In the Form Fields area, specify the form objects you want to include on the
insert page’s HTML form, and 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 be displayed 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 text 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 accepted 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.
If you use ASP.NET, you can choose to use web form control.
Click OK.
adds both an HTML form and an Insert 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