Understanding records

This is an introduction to 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 based on the column types of a database table as defined in a database schema.

Records are used in interactive instructions like INPUT to control forms, and record are also 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