Understanding records

A record defines a structured variable, where each member can be defined with a specific data type. Records can contain other records, or arrays.

DEFINE person RECORD
            id INTEGER,
            name VARCHAR(100),
            birth DATE
       END RECORD

Records are typically used to store the values of a database row. Records can be defined according to the columns of a database table as defined in a database schema. Records are used in interactive instructions such as INPUT or DIALOG for user input, and can be used in INSERT and UPDATE SQL instructions to update the database table.

SCHEMA stores
DEFINE cust RECORD customer.*
-- cust is defined with the column of the customer table