hFileParameter (Variable type)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / Types of HFSQL variables

Properties specific to hFileParameter variables

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

hFileParameter (Variable type)

In french: hParamètreFichier

Available only with this kind of connection

The hFileParameter type is used to define the data files taken into account by a scheduled optimization task. The characteristics of these data files can be defined and modified using various WLanguage properties.

This type of variable is used by the hScheduledOptimization type.

Note: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.

Example

// Recalculate the statistics for the files found in "MyDatabase",
// every Saturday at 23:00
Optim is hScheduledOptimization
Optim.Description = "Recalculating the statistics for the files found in the MyDatabase database"

Optim.Scheduling.Month = "*"
Optim.Scheduling.DayOfWeek = "Saturday"
Optim.Scheduling.Hour = "23"
Optim.Scheduling.Minute = "0"

Optim.File[1].Name = "MyDatabase"
Optim.File[1].Option = hOptStat

HAddScheduledOptimization(MyConnection, Optim)

Properties

Properties specific to hFileParameter variables

The following properties can be used to handle hFileParameter variables:

Property name	Type used	Effect

Name	Character string	Name of the file to process. This name can correspond to a string of the following type: <Nom de la base>/<Nom du fichier>: Optimization of the "File name" file in the "Base name" database. <Nom de la base> Optimization of all data files contained in the "Database name" database. "*": Optimization of all data files in all server databases.
Option	Integer constant	Optimization options: hOptIndex: causes data files to be reindexed. A hot re-indexing operation is performed on the indexes and on the full-text indexes. hOptStat: Recalculates data file statistics. The result is similar to the use of HStatCalculate. This process is a hot process.
Password	Character string	Password of the encrypted data files. This property is available in write mode.