Detail table

Detail table (component - source of data, result of execution of parameterized SQL-query). Realizes the nested tables. The nested table is a field for the table-owner. The nested tables are stored separately from the basic tables. In difference from usual tables, they can not have own name as since they are actually considered as the imprescriptible components (columns) of the parental table.

Properties of a component: Left, Name, Top.

Active - defines whether the parameterized query is activated or not, possible values - True, False. False value is assigned by default.  If property has True value the results visualization of query execution in a component, hooked up to a considered data set with a name, definite in Name property is implemented.

Master dataset name (the controlling data set) - defines a name of the leading table, query or other detailed table (cyclic links are not supposed!).

Master fields (controlling fields) - for indication of a field from a controlling data set.

It is used for selection of data at activation of parameterized query.

Detail field - for the indication of a field from the table specified in Table name property. It is used for selection of data at activation of parameterized query.

Table name - is used to set link between the table of a database and a component of DB Table. Is selected by using the dialog of table choice from a DB tables definite by user in Base Administrator.

Fields parameters - dialog of a choice of the fields list which will participate in parameterized query at its activation (Active property). By means of this dialog it is possible to specify directly fields from the table specified in Table name property, their order in parameterized query, a type of sorting.

Note 1: If the detail table is a leading data set for other detail table at the setting of fields parameters it is necessary to specify a field which is specified in property "Master fields " for the conducted detail table.

Note 2: If fields parameters are not specified, all fields from the table specified in Table name property will participate in parameterized query.