DBase table |
dBase table (component - a source of data). It represents a data set that can be connected with one form table dBase. Data set returned by the dBase Table component, is based on a navigation mode of data access. Properties of the component: Left, Name, Top. Active connection - specifies a way of connection to the DB table, the possible values are - True/False. By default - False. At value of property is the True, active connection to the table is carried out, it means that there are synchronised the actions with the table (movement on records, a sampling in the connected table) realized on all the user forms, where active connection to the same table is carried out. For example, two forms Form1 and Form2 are created, which contain components of DB_Edit1 and DB_Edit2 accordingly. The components of DB_Edit1 and DB_Edit2 are connected to the same database table (properties Dataset name of both components have identical value). At value editing of certain field of the current record by using the DB_Edit1 component of Form1 the displayed value automatically changes in the DB_Edit2 component of Form2. Master dataset name - specifies a name of the master table. It is assigned at linking the tables, if the current table is the detail one. At the design moment the master table should be open. Master fields - the dialogue of identifying the key (indexed) fields, by which the link between master and detail tables is carried out. Table name - a filename is specified, it is used to set the link between the database table and the DB Table component. It is selected by using the dialog of choosing a table from a set of DB tables definite by user in Base Administrator. Index field names, Index name - set a current index. The current index is selected from the indexes list which have been set at creation of the table. Both properties are similar and are used practically equally, but value of Index name property is the index name specified at creation of the table, and value of the Index field names property - a field name for which the index was created. If the index consisting of several fields is used, then for the Index name property the name of this index is still set, and for the Index field names property you must list (separated by semicolons) the names of fields which are included into this index.
|