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 SELECT
, UPDATE
, and
DELETE
rows in the database, and handles the SQL transactions.
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). |