Form_uidata.4gl

The Form_uidata.4gl file includes functions to retrieve and manage the database data. It defines the records for the database columns and tables; creates and fills a dynamic row of data; creates and fills a dynamic row of record keys; contains the SQL statements to INSERT, SELECT, UPDATE, and DELETE rows in the database; and handles the SQL transactions.

Table 1. Generated functions
Function Description
getKeys Create and fill a dynamic array of Business Record(BR) Unique Keys (UK).
getDataByKey Get data from a given Business Record (BR) Unique Key (UK) (may be a composite key).
getDataArray Create and fill a dynamic array of Business Record (BR) fields.
insertRow Insert a row in the database.
updateRow Update a row in the database.
deleteRow Delete a row in the database.
deleteRowwithConcurrentAccess Delete a row in the database.
checkRow Check a row in the database.
checkRowConcurrentAccess Check a row in the database.
DescLookup Retrieve data according the descending lookup after update of the field.
AscLookup Retrieve data according the ascending lookup after update of the field(s).
fillArray Populate an array of key/value pairs.
computeFields Compute FORMONLY fields of the Business Record (BR).