hFileParameter (Type of variable)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Properties specific to the description of hFileParameter variables

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

hFileParameter (Type of variable)

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 by several WLanguage properties.

This type of variable is used by the hScheduledOptimization type.

Note: See Declaring a variable for more details.

Versions 17 and later

This type of variable is now available for the iPhone and iPad applications.

New in version 17

This type of variable is now available for the iPhone and iPad applications.

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)

Remarks

Properties specific to the description of hFileParameter variables

The following properties can be used to handle a hFileParameter variable:

Property name	Type used	Effect

Password	Character string	Password of the encrypted data files. This property is available in read-only.
Name	Character string	Name of the file to process. This name can correspond to a string of the following type: <Database Name>/<File Name>: Optimizing the "File Name" file in the "Database Name" database. <Database Name>: Optimizing all the data files found in the "Database Name" database. "*": Optimizing all the data files found in all the databases of the server.
Option	Integer constant	Optimization options: hOptIndex: Provokes the reindexing operation on the data files. A hot reindexing operation is performed on the indexes and on the full-text indexes. hOptStat: Provokes the recalculation of statistics on the data files. The result is similar to the use of HStatCalculate. This process is a hot process.

Note: These properties can be used with one of the following syntaxes:

<Variable name>..<Property name>
<Variable name>.<Property name>