Functions relating to 'Record'

Example

 

CustomerRec is Record of CUSTOMER

Functions that handle the Record type

The following functions use the Record type:



HAdd

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).

HCopyRecord

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.

HExtractMemo

Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk).

HInfoMemo

Returns the characteristics of binary and text memos.

HLinkMemo

Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item.

HListItem

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.

HReset

Initializes:

one or all variables of file items with their default values.

one or all items of a Record variable with their default values.

HRetrieveRecord

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.