TOC PREV NEXT INDEX



Database actions


Database actions are enclosed by angle brackets on the list (<>). They represent different commands which the database may execute. They are:

Open Connection and Close Connection will cause the working model to open or close the database connection specified on the Connection page. If the working model does not open a database connection, it cannot perform database operations. Databases may automatically close connections after a period of inactivity; the close connection action can be used to ensure that the connection was in fact closed.

If the database was not opened with the "Commit all changes immediately" option enabled, then the Commit Changes action must be performed to save changes to the database; the Rollback Changes will undo all changes made since the last Commit.

The Execute Statement action will cause the specified SQL statement to be executed by the database. If the statement is a SELECT statement, then each of the Goto actions (Next, Previous, Last, etc...) will display different records. The Clear All Fields action will clear the display of the results.

All database actions except for Goto Specific Row can be associated with objects which can fire an ActionEvent. This includes

Goto Specific Row allows the display to jump to a particular record. This action only makes sense when used with user interface items where it is possible to choose one possibility from many, so the list will only display the following objects:

When a database action is selected from the UI tree, a list of possible items is generated on the right. To associate the database action with an item or items, simply click once on the desired item in the list on the right. A second click will unselect the item. A new level will be added to the tree to indicate which items will trigger the action.


Data Representations, Inc.
http://www.datarepresentations.com
support@datarepresentations.com
sales@datarepresentations.com
TOC PREV NEXT INDEX