RECORD

RECORD data type represents an ordered set of members. The set is called a program record, its members are variables of any 4GL data type; they can be used in any combinations to construct a record, the order in which they are included into a record is fixed. Members of a record can be of any 4GL data type:

• Simple Data Types
• Large Data Types (BYTE and TEXT)
• Structured Data Types (ARRAY and RECORD)

RECORD data type has the following structure:

Table Id	The name of a database table. It may include other table qualifiers if necessary, such as table owner, server name and database
Record Member	One or more record members separated by commas

 

END RECORD keywords must be used to specify the end of the record declaration, if a record contains one or more members. However, if you use the RECORD LIKE keywords to declare a record like all the columns of a specified database table, the END RECORD keywords are not required and will cause a compile-time error.

 

Here are the functions and methods that can be used with a variable of the RECORD data type:

arr_count() - returns a positive whole number, typically representing the number of records entered in a program array during or after execution of the INPUT ARRAY statement,

arr_curr() - function returns the number of the program record within the program array that is displayed in the current line of a screen array, or the last active screen array if there is no current array,

scr_line() - returns a positive integer that corresponds to the number of the current screen record in its screen array during a DISPLAY ARRAY or INPUT ARRAY statement.