Component dbscroller
Description
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.
Format
< dbscroller ... > ... < /dbscroller >
Details
| Include File: | dbscroller.hei |
| Session Mode: | create |
Properties
| Property | Kind | Description |
| Oid | ||
| Relation | Database Relation to be shown | |
| Number | Maximal number of records | |
| Autoread | Automatically execute a query | |
| Showconstraints | Show Constraints for debugging | |
| Showsql | Show SQL query (for debugging) | |
| Msgallowed | Accepted messages. The enabled functions can be activated from the browser. |
Messages
| Kind | Description |
| search | 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 | Query search. The query can use dbqueryfield to compare key fields with database fields. |
| display | Query search. The key fields of the message must be equal to the fields in the database with the same name. |
| clear | Clears the scrollers content. |
Superclass
The component inherits Attributes, Methods, and Hookmethods from the following superclasses:
panel The ff attribute and the access functions panelobj(n) and panelfield(n) are important. See
Hooks
onempty () Called if an empty dbscroller is displayed. An empty scroller displays nothing unless onempty is defined.
onquery () Called immediately before the database is queried.
onmsg (msg) Called before a message msg is processed.
© 1996-2024 H.E.I. All Rights Reserved.
