// Add a record into a file
// (record described by programming)
Customer.LastName = "Clark"
Customer.FirstName = "Vince"
Customer.Address = "Palm lane"
Customer.City = "San Francisco"
Customer.Zip = "94102"
Customer.Country = "USA"
HAdd(Customer)
// Forces a write operation into Customer file
HFlush(Customer)
Syntax
<File Name>: Character string (with or without quotes)
Name of data file used.
If this name is not specified, HFlush handles the last data file used by the last function for HFSQL management (starting with the letter H).
If this parameter corresponds to "*", HFlush will be applied to all opened data files.
Caution: In this case, the execution of function can be quite long.
This parameter can also correspond to the name of a group of files (or custom-folder) defined in the analysis.
Remarks
HSecurity and HFlush functions
HSecurity and
HFlush can both be used to force a physical write operation on disk.
However:
- HSecurity is used to force a write operation into the data files used during each write operation. This write operation is automatically performed by the HFSQL engine. The data files used are not closed during this write operation. The speed of the write-to-file operation is slower.
- HFlush is used to force a write operation into the data files used during the call to this function. The data files used are closed then re-opened during this write operation. The speed of the write-to-file operation is not slowed down.