Specify the individual database field to display for each control in the Property Sheet.
|
Go to: |
Property Sheet, FieldValue control, Database field property |
The “Database field” property designates from where the data is retrieved or saved. The selection criteria of the control’s associated Record control or Table control are used. This option allows you to select a database field based on the surrounding Record tag properties you previously specified. You do not need to specify the source of the record repeatedly for each of the field values contained in the record.
|
|
|
Specify the individual database field to display for each control in the Property Sheet. |
This is common for FieldValue tags enclosed within a surrounding Record or Table tag where the objective is to display a related set of fields coming from a single selected record. In this case, the Record or Table tag specifies the record that is selected and the FieldValue controls display the individual fields.
|
|
In this example, the customer information is sourced from a single record in the Customers table and displayed on the web page. The Record tag is bound to the Customers table. The individual FieldValue tags are set to source their data from specific fields in the Customers table. |
|
|
In this example, the name, address, and other contact information is collected from the web page and inserted into the Customers table in the database. The Record code generation tag is bound to the Customers table. The individual FieldValue tags would typically have their query bound to “Add new record”. |
This option also applies to the FieldValue tag if it is enclosed within a row of a table being displayed. This is meaningful in the context of a FieldValue tag in a table in which the "current row" in the table is bound to a particular record. As the table iterates over each record in the result set, each corresponding record is fetched and the appropriate field values retrieved and displayed.
Furthermore, you can add additional criteria to further filter the previously defined query or the records from the table.
If you select a query from the dropdown list, then the “URL parameter” option will not be available, though you can still add additional “WHERE” clauses.
You can add additional filter criteria regardless of whether a table or a query is selected and regardless of whether a URL parameter is specified.
|
Options |
Description |
|
Table, view or query |
Specifies the database table containing the field to be displayed. |
|
Field |
FieldValue Control Type Options
