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).