To meet your needs, we constantly work to improve Querix products.
This means that Lycia documentation is developing as well.
In case you have found a certain dissonance between the provided information and the actual behavior of Lycia 3 and/or your applications, please, let us know about this via documentation@querix.com so that we can introduce the necessary changes to our documentation.
Thank you for your attention and cooperation.
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:
|
Element |
Description |
|
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.