Display the scrollable result of a database query. Displays the result of a database query.
Initially all records of a certain Relation are selected.
The maximal number of records display is given in the
Number Parameter. It is set to 3 initially which
is fine for debugging.
By clicking on constrain you can add constraints
on the records selected. By clicking on fields you can
select what fields should be selected. Using Join Relations
you can create queries on multiple database relations.
Database Relation to be shownMaximal number of recordsAutomatically execute a queryShow Constraints for debuggingShow SQL query (for debugging)
Accepted messages. The enabled functions can be activated from the browser.
if (top.editmode!="new") {
- Constraints
Add constraints, to select a certain set of database records
- Fields
Select the fields to be shown
- Join
Relations Add other Relations to query
}
Automatic query search. The key fields
of the messages are compared with the fields
of the same name contained in the database.
Default comparison operator is like "%...%".
Other operators can be selected using dbfieldoperator. Query search. The query can use dbqueryfield
to compare key fields with database fields. Query search. The key fields of the message
must be equal to the fields in the database with the
same name. Clears the scrollers content.
Called if an empty dbscroller is displayed.
An empty scroller displays nothing unless onempty is defined.
Called immediately before the database is queried.
Called before a message msg
is processed.