|
|
|
|
|
|
|
|
|
|
- Characteristics of created data file
- Additional files created
- Managing passwords
- Managing fatal errors when creating a data file
- Managing non-Latin character sets
- Replication: Range of Identifiers
- Priority for defining the location of log files
- Creating an existing table
- Constraints for referential integrity
- OLE DB Oracle: Create a table containing a binary memo
- OLE DB: Creation of a table containing automatic identifiers
- Managing indexes
- Create a data file from its description in the data model editor
- DATE and TIME items with the Native SQL Server Connector
- HCreation and Native SQLite Connector
HCreation (Function) In french: HCréation
 Not available with this kind of connection
Creates an empty data file (extension ".FIC") with index file, full-text index file, spatial index file and memo file if required. This function can also be used to delete all records from a data file. In this case, the record in memory is not canceled. To initialize it, use HReset. Note You can activate the automatic creation of non-existent data files in the project description ("Data files" tab in the project description, option "Automatically create the data files when they are opened"). HCreation is automatically used if the data file does not exist when it is handled for the first time.
Syntax
<Result> = HCreation(<Data file> [, <Password> [, <Path of the JNL file> [, <Path of the JournalOperation file> [, <Options>]]]])
<Result>: Boolean - True if the data file was created,
- False if a problem occurs. HError is used to identify the error. If a fatal error occurs, a specific process is required to continue the program and to check whether the data file was created (see the Notes).
<Data file>: Character string Name of data file to create.
<Password>: Optional character string - Password associated with the data file.
  HFSQL data file password is case insensitive. - Empty string ("") if no password is used.
<Path of the JNL file>: Optional character string Access path to the JNL file associated with the logged data file. This parameter is only taken into account if the data file is logged. In this case, <File name>JNL.fic will be created at the specified location.
<Path of the JournalOperation file>: Optional character string Access path to the JournalOperation file and to the JournalIdentification file associated with the logged data file. The JournalOperation file contains all the operations performed on the logged data file. This parameter is only taken into account if the data file is logged.
<Options>: Optional Integer constant Options for creating the data file: | | | hChangeCharset | The character set defined by ChangeCharset will be taken into account in the new data file. Sorts, searches or other types of operations performed on string keys (strings, characters, date and time) will use the new character set. | | hNoLink | Integrity management: links are not updated on the server (creation, modification, deletion as the case may be).
Reminder: by default, when a data file is created, links are updated on the server..
|
Remarks Managing passwords - The password can be defined:
- when the data file is created by HCreation.
- before the data file is created by HPass.
- If the data file existed and if it was password protected, the data file is recreated, even if the password changes or does not exist anymore.
Attention Password is independent of data encryption. Data encryption must be configured when describing the data file in the data model editor ("Details" tab).
Managing fatal errors when creating a data file If a fatal error occurs when creating a data file, it may be interesting to continue the program while checking whether the data file was created or not. To do so, we recommend that you perform the following exception process:
WHEN EXCEPTION IN
HCreation(PARENT)
DO
Error("HFSQL error: " + HError())
ELSE
Trace("The file is created")
END
Create a data file from its description in the data model editor The data file can be directly created from its description in the data model editor. To do so, select "Create the data file" and select the directory where the data file must be created.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|