Declaring a Record variable

• If the parameter < of the data file name in the analysis> is indicated, the Record is associated with an description of one of the data files present in the analysis.. In this case, you have the ability to handle the different record items.
• If the <of the data file name in the analysis> parameter is not specified, the Record structure will be built dynamically according to the buffer of the file that will be allocated to it.

Accessing the items

• To assign an item of the variable:
  
  <Variable name>.<Item name> = <Value to assign>
• To retrieve the value of the items:
  
  <Value> = <Variable name>.<Item name>

Reading and assigning a Record variable

• To store the buffer of a data file in a Record variable:
  
  <Name of record variable> = <Name of data file>
• To assign the buffer of a data file from a Record variable:
  
  <Name of data file> = <Name of record variable>

Special cases

• HRecordToString used on a Record variable returns a character string containing the value of each item separated by a TAB character.
• No compilation error occurs if a Record variable with type on a data file is assigned with the buffer of another data file. An homonymic copy of buffers is performed: only the items with the same name of each buffer will be assigned. The other items will be not assigned.
• Only JSON serialization is available for this type of variable (Serialize). No deserialization is possible.

Functions that handle the Record type

Versions 09 and later HAdd New in version 09 HAdd 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).
Versions 09 and later HCopyRecord New in version 09 HCopyRecord 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.
Versions 09 and later HExtractMemo New in version 09 HExtractMemo 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).
Versions 09 and later HInfoMemo New in version 09 HInfoMemo HInfoMemo	Returns the characteristics of binary and text memos.
Versions 09 and later HLinkMemo New in version 09 HLinkMemo HLinkMemo	Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item.
Versions 09 and later HListItem New in version 09 HListItem 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.
Versions 26 and later HRecordToString New in version 26 HRecordToString HRecordToString	Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
Versions 09 and later HReset New in version 09 HReset 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.

Properties specific to the description of Record variables