- Managing automatic identifiers
- Writing deleted or crossed records
- Version of the data file after a write operation
- Managing the binary memos
- If you are using HWrite with a database in Hyper File 5.5 format
- Browsing and writing a record
HWrite (Function) In french: HEcrit
 Not available with this kind of connection
// Write a record at the end of file
HWrite(Customer, HNbRec() + 1)
Syntax
<Result> = HWrite([<File name> [, <Record number> [, <Options>]]])
<Result>: Boolean - True if the writing was performed in the data file,
- False if an error occurred (lock, ...): the record is not modified. HError is used to identify the error.
<File name>: Optional character string (with or without quotes) Name of data file used. If this name is not specified, HWrite handles the last data file used by the last function for HFSQL management (starting with the letter H). <Record number>: Optional integer Number of the record to write. The record loaded in memory is re-written on the specified record.
If this number is greater than the total number of records found in the data file, intermediate deleted records will be created in order for the sequential reading of data file (HRead) to be consistent.
If this parameter is not specified (equal to 0 or to the hCurrentRecNum constant), HWrite modifies the current record found in the data file. <Options>: Combination of optional constants Configures:- the mode for calculating the automatic identifier: See Managing the automatic identifier during an addition for more details.
| | hWriteDefault
(Default value) | If the written record is not a deleted record, the automatic identifier (if it exists) of the record in the data file is re-used.
If the written record is a deleted record, a new automatic identifier is calculated for the record.
The hWriteDefault constant is ignored if hWriteDefault is specified with one of the other constants. | | hSetIdAuto | The automatic identifier is not calculated during the write operation: The value of the identifier is the one stored during the write operation.
The next value of the identifier calculated by the HFSQL engine will correspond to the greatest value of the identifier in the file +1. | | hForceIdAuto | The automatic identifier is not calculated during the write operation: The value of the identifier is the one stored during the write operation. | | hRecalculateIdAuto | The automatic identifier of the record will be re-calculated during the write operation. This constant has priority over hForceIdAuto and hSetIdAuto. |
A WLanguage error is generated if the three constants (hForceIdAuto, hSetIdAuto and hRecalculateIdAuto) are used at the same time. - the lock mode applied to the record.
If no lock constant is specified, the record is not locked.
| | | hLockWrite | Lock in write mode: the written record will be locked in write mode. This record can be read by another application but it cannot be modified by another application. Only the current application can modify it or unlock it. | | hLockReadWrite | Lock in read/write: the written record will be locked in read/write. This record cannot be read or modified by another application. Only the current application can modify it, read it or unlock it. | hLockNo
(Default value) | No lock (even if HStartLock was used): the written record is not locked. |
Remarks Managing automatic identifiers By default, the "automatic identifier" item is automatically updated when a record is added into a data file. The hForceIdAuto and hSetIdAuto constants are used to modify the default behavior of the automatic identifier. Managing the binary memos When a record is modified, the memos are modified if necessary (if the management of memos is enabled by HSetMemo). Reminder: to initialize a binary memo item, use HLinkMemo.
This page is also available for…
|
|
|