PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Properties specific to the description of data files
  • How to describe the data files by programming?
  • Handling the items of a data file described by programming
  • LogMethod
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
File Description (Type of variable)
In French: Description de Fichier (Type de variable)
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
A File Description variable is used to describe one or more data files by programming. The description of each data file is validated by HDescribeFile.
After this validation:
  • This data file can be handled like any other data file described in the analysis.
  • The "File Description" variable is reinitialized and it can be used to describe another data file by programming.
Versions 17 and later
iPhone/iPad This type of variable is now available for the iPhone and iPad applications.
New in version 17
iPhone/iPad This type of variable is now available for the iPhone and iPad applications.
iPhone/iPad This type of variable is now available for the iPhone and iPad applications.
Versions 18 and later
Universal Windows 10 App This type of variable is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This type of variable is now available in Windows Store apps mode.
Universal Windows 10 App This type of variable is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This type of variable is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This type of variable is now available in Universal Windows 10 App mode.
Universal Windows 10 App This type of variable is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
AFile is File Description
MyFile1, MyFile2 are File Descriptions
// Describe the "CUSTOMER" file
AFile..Name = "CUSTOMER"
AFile..Type = hFileNormal
AFile..FicCryptMethod = hCryptStandard

// Describe the file items
...

// Validate the description of "CUSTOMER" file
HDescribeFile(AFile)
Syntax

Declaring one or more descriptions of data files Hide the details

<Variable Name> is File Description
<Variable Name 1>, <Variable Name 2> are File Descriptions
<Name of Variable>:
Name of the "File Description" variable to declare.
Note: The a and an keywords are optional: they provide better readability.

Describing a "File Description" variable Hide the details

To describe a "File Description" variable:
Use the WLanguage properties specific to the descriptions of data files. See remarks for more details.
To validate the description of a "File Description" variable:
Remarks

Properties specific to the description of data files

The table below presents the properties specific to the description of data files:
Note: The properties in bold followed by a star (*) must necessarily be initialized when a data file is described by programming.
Property nameEffect
MmoPackMethodCompression mode of the MMO file (containing the text and binary memos) associated with the data file
FicCryptMethodEncryption mode of the data file
MmoCryptMethodEncryption mode of memo file (.MMO extension) associated with the data file
NdxCryptMethodEncryption mode of index file associated with the data file
CtAccessType of access to the file during the OLE DB connection to a specific table (while taking into account the modifications performed by HConnect)
CtDescribedAccessType of access to the file during the OLE DB connection to a specific table (while ignoring the modifications performed by HConnect)
CtDatabaseOLE DB data source during the OLE DB connection to a specific table (while taking into account the modifications performed by HConnect)
CtDescribedDatabaseOLE DB data source during the OLE DB connection to a specific table (while ignoring the modifications performed by HConnect)
CtDescribedCaptionCaption of the connection to the OLE DB data source
CtDescribedPasswordPassword used to open the file during an OLE DB connection
CtOLEDBProviderName of the OLE DB server used (while taking into account the modifications performed by HConnect).
CtDescribedOLEDBProviderName of the OLE DB server (while ignoring the modifications performed by HConnect).
CtUserNameName of the user during an OLE DB connection (while taking into account the modifications performed by HConnect).
CtDescribedUserNameName of the user during an OLE DB connection (while ignoring the modifications performed by HConnect).
FormatFormat of data in the data file (ANSI or Unicode).
HugeFileMaximum size of a data file.
Versions 23 and later
Unalterable
New in version 23
Unalterable
Unalterable
Mode for managing the unalterability of data file.
LogMethodLog mode of a data file.
WDD55PasswordPassword that will be used to handle a file defined by programming in Hyper File 5.5 format in an analysis in WINDEV format.
Name ( * )Name of HFSQL file.
Name55Logical name of a file in Hyper File 5.5 format found in an analysis in WINDEV format.
DescribedNameLogical name of a data file.
PhysicalNamePhysical name of data files.
DescribedPhysicalNamePhysical name of HFSQL files (while ignoring the changes of name performed by HChangeName).
NullSupportedManagement mode of NULL value.
Versions 19 and later
RepeatableReadSupported
New in version 19
RepeatableReadSupported
RepeatableReadSupported
The file is used in a HFSQL Client/Server transaction that includes a "Repeatable Read" isolation mode.
DirectoryPhysical directory of HFSQL files (this property takes into account the changes of directory performed by HChangeDir or HSubstDir).
DescribedDirectoryPhysical directory of HFSQL files (this property ignores the changes of directory performed by HChangeDir or HSubstDir).
LogDirectoryDirectory of log file described in the analysis.
TextItemCompletedFills (or not) the text items with space characters.
SecureSecurity level regarding the encryption of data files.
TypeType of data file.
WDD55Path of the WDD file in 5.5 format used to handle the data files in 5.5 format in a WINDEV application.

How to describe the data files by programming?

To describe the data files by programming, you must:
  1. Declare the "File Description", "Item description", "FullTextIndex description" and "Link description" variables (if necessary).
  2. For each data file:
  3. Describe (if necessary) the characteristics of links via the HFSQL properties.
  4. Validate (if necessary) the description of each link (HDescribeLink).

Handling the items of a data file described by programming

When creating a data file in the data model editor, the names of the data files and items are automatically recognized by the compiler.
When creating a data file via a "File description" variable, the names of data file and items are defined by ..Name. These names are not automatically recognized by the compiler. A compilation error occurs if these names are used to identify the data file or the items.
In order for the name of data file described by programming to be recognized by the compiler, this file name must be declared as data source via the data source keyword. This data file can be handled by its name in the code editor.
For example:
AFile is File Description
...
AFile..Name = "CUSTOMER"
...
HDescribeFile("CUSTOMER")
...
CUSTOMER is Data Source
...
HReadFirst(CUSTOMER, "CUSTNAME")
Note: The name of data file can also be declared with the Extern keyword. However, the execution speed of process will be slower.

LogMethod

When the data file is described by programming:
  • if the data file is logged and if no item is logged, all the items (except for the composite keys) are automatically logged.
  • if the data file is logged and if at least one item is logged, the other items are not modified.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment