The DBTable components maintains a database table in your database.

Property Description Values
ActiveRepresents the status of the componenttrue/false
AutoIncrementField that will be incremented on each insert. This is independent from the 'autoincrement' on database level. On occasions where you can't use a database trigger, you can use this field to increase the value based upon PHP code. (select max… +1)fieldname
AutoSyncAutomatically synchronize result dataset after update
CustomFieldsProperty editor to add custom fields, i.e. for lookups. This is bound to the dbtable, a better option is to retrieve the data when required (i.e. at the grids)
DBConnectionName of the predefined connection id's.Will be filled by default by all the connections available for your application. If there is only one, then this connection id is used by default.
FieldsThe fields of the table that will be used by the components refering to this component.It will open a property editor containing all fields of the table and allows to select / unselect the fields to be used. This is a mandatory step. If you do not open this property editor, no fields will be selected causing a generation error/warning.
FilterAn optional filter to be used in the 'where' clause of a SQL statement.string. Sample: 'myfield > 10'
MasterDataMappingMapping of keyfields between master and detail
MasterDataSourceDatasource of the master table (only required on master-detail relationships)
ResultCacheChanges the search result in a sqlite table. Needed for bidirectional access. SET TO FALSE if this table is used as detail. Because of the caching, accessing this table will reopen the last result causing wrong results if you are using it as detail. B.t.w. if you set a master datasource this field is automatically set to false.True,false
ResultLimitCountNobody is scrolling hundreds of pages to find a result. This field limits the amount of records found on a search for a better performance.10000
ResultLimitOffsetStartpoint within a resultsetinteger
ResultlimitstmStatement for limiting resultset. Needed for compatibility. If not set, the system will use the settings at the database. Required due to the fact that there is no standard Ansii syntax for limiting result
ResultUseLimitIf set to false then the full resultset will be retrievedtrue, false
SubFilterSee Filter. This filter is applied to the resultset, not on the primary query.
TableThe name of the table that is accessedDropdown with tablenames
Property Description Values
onAfterExecuteTriggers when the sql statement gets fired
onBeforeExecuteTriggers after the sql statement has been fired

No additional events

  • dbtable.txt
  • Last modified: 2020/08/17 15:04
  • by aducomadmin