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	Id
Relation	Relation Name	Database Relation to be shown
Number	Integer	Maximal number of records
Autoread	Checkbox	Automatically execute a query
Showconstraints	Checkbox	Show Constraints for debugging
Showsql	Checkbox	Show SQL query (for debugging)
Msgallowed	String(60)	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:

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.