Example
CustomerRec is Record of CUSTOMER
Functions that handle the Record type
The following functions use the Record type:
Adds: •the record found in memory into the data file (query or view). •the record found in a Record variable into the data file (query or view). |
|
Copies: •the content of current record (loaded in memory) into the current record of a data file. •the content of Record variable into the current record of a data file. |
|
Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk). |
|
Returns the characteristics of binary and text memos. |
|
Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item. |
|
Returns the list of items: •found in a data file ( a query or a view) known to the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. •found in a Record variable. |
|
Initializes: •one or all variables of file items with their default values. •one or all items of a Record variable with their default values. |
|
Returns the content of the current record (in a file, a view or a query, ...). |
Remark: To reinitialize the content of a Record variable, you have the ability to use VariableReset.