Common InformationsIn order to use data from a database in a Form or aReport, the data source must be made available.
In Forms and Reports STableElements resp. PTableElemenents are inserted. The propertie RecordSource on the propertie page will be set with a becomes by the data source selection dialogue with a Table or a Query with the Data source selection dialog
In Reports the property RecordSource of the Report itself can be set.
With large volume of data the propertie OptimizeForLargeTables can be set true, in order to accelerate the data access. At a small number of data records this propertie would slow the queries down however. It depends on the concrete application, whether it is better, to set this propertie on true and should be tested in marginal cases.
The propertie OrderBy defines the column according to that the data records will be sorted. The sort sequence is defined in the propertie SortOrder.
Die properties CascadeDelete and CascadeUpdate in STableElements will be discribed in the sectionCascading properties Update / Delete.
Now the Beans, which represent the content of the TableElementes and can change it in forms, can be inserted.
At Reports that are P2DBarCode, PBarCode, PCheckBox, PFormattedField, PPicture or PTextArea. The PTableElement will be defined by the propertie TableSource. The table columnwill be set by th propertie ControlSource.
At Forms that are SCheckBox, SComboBox, SFormattedField, SOptionsGroup, SPicture or SScrollTextArea. The STableElement will be defined by the propertie TableSource. The table columnwill be set by th propertie ControlSource.
The SScrollTable shows the data records in a table view. The columns will be defined with TBeans. Previous the datasource must be ste with the propertie TableSource.
With a SNavigator one can turn over the individual data records. The data source, by which is to be turned over, is set by the characteristic TableSource. The navigator indicates which buttons to show by the properties ShowCommit, ShowDelete, ShowFirst, ShowInsert, ShowLast, ShowNext, ShowPrevious, ShowRefresh und ShowRollback
The Beans PFormattedField, SCheckBox, SComboBox, SFormattedField and SOptionsGroup can filter TableElements according to their values. FilteredTableSource determines the TableElement, FilteredControlSource determines the column and FilterOperator determines the operator by wich to be filtered. So an query can be filtered according to the selected data record.
The properties SearchedControlSource and SearchedTableSource of the Beans SComboBox and SFormattedField resemble the properties FilteredTableSource and FilteredControlSource, since they likewise filter tables. However they position the selected data records and do not execute a new query.
In the component tree the columns indicated to the database are shown. If these are clicked and dragged into the form or the report, an appropriate SFormattedField with a SLabel resp. a PFormattedField will be inserted, with the correct entries for the properties TableSource, ControlSource and LabelForComponent.
In Reports the possibility exists of grouping data records by report groups according to certain criteria