cDBQuery
The DBQuery is inherited from the DBTable component and maintains a database table in your database. In this case, you must supply your own SQL instead of using a table name. If you need to use CRUD then you can apply a CRUD component to supply individual SQL statements for each action.
DBQuery is extremely useful for creating reporting grids based upon free queries.
Properties
|
Description |
AutoSync |
Automatically synchronize result dataset after update |
DBConnection |
Name of the predefined connection id's. |
Fields |
The fields of the table that will be used by the components referring to this component. |
MasterDataMapping |
Mapping of key fields between master and detail |
MasterDataSource |
Datasource of the master table (only required on master-detail relationships) |
Query |
Reference to a query setup. Opens the Query Builder to create your SQL in a visual way. Useful for complex queries, or if you require links (cloud connection) to another query in another application. |
ResultCache |
Changes the search result in an 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 data source this field is automatically set to false. |
ResultLimitCount |
Nobody is scrolling hundreds of pages to find a result. This field limits the number of records found on a search for better performance. |
ResultLimitOffset |
Startpoint within a resultset |
Resultlimitstm |
Statement 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 |
ResultUseLimit |
If set to false then the full resultset will be retrieved |
SQL |
SQL statement to execute. Use only if you haven't used the query property. Very useful in applying SQL statements in the code. |
SQLCrud |
Reference to a SQL Crud component (containing crud SQL statements) |
PHP Events
|
Description |
onAfterDelete |
Fires after the database has completed the delete operation |
onAfterInsert |
Fires after the database has completed the insert operation |
onAfterOpen |
Fires after the table has been opened (executed the basic SQL query) |
onAfterUpdate |
Fires after the table has been completed the update operation |
onBeforeDelete |
Fires before the database will perform the delete operation |
onBeforeInsert |
Fires before the database will perform the insert operation |
onBeforeOpen |
Fires before the database will perform the basic SQL query |
onBeforeÙpdate |
Fires before the database will perform he update operation |
Javascript events
No additional events