|
| This button on the menu is not a component that can be added to applications, but a tool to facilitate editing the window-definition for the application to be created. |
The events that are recognized for components of the type SQL data are:
AddNew, Create, DeleteRecord, Destroy, Error, MoveFirst, MoveLast, MoveNext, MovePrevious, MoveTo, UpdateControls, UpdateRecord and Validate.
This facility is only enabled when the MSM-SQL system is installed in the current workspace within the active database in MSM-Workstation.
When active, this button gives access to the Schema and Table in
the MSM-SQL Data Dictionary.
It allows for a very quick and easy way of providing
data entry screens.
There is a number of properties for
handling the moving to a next record in a query and updating or
deleting records.
There is no default property for SQL data.
The property list for SQL data is:
| Property Name (MSM-Workstation) | Property Name (MWAPI) | Default Value | Value Range |
|---|---|---|---|
| Changed | CHANGED | Boolean value | |
| Connection | Alphabetic and numeric characters | ||
| Container | Free text | ||
| DataDistinct | 0 | Boolean value | |
| DataFilter | Free text | ||
| DataSort | Free text | ||
| Message | ZMESSAGE | Free text | |
| Name | Name of component (current window) | ||
| PosLeft | POS | Positive numeric value | |
| PosTop | POS | Positive numeric value | |
| PosUnits | POS | Unit Specification | |
| ReadOnly | Boolean value | ||
| RecordSource | Free text | ||
| Type | TYPE | Data | Type of component |
Go back to the alphabetic list of components.