|
|
|
|
|
|
|
|
|
|
- Properties specific to hFileParameter variables
- Functions using hFileParameter variables
hFileParameter (Variable type)
 Disponible solo con este tipo de conexión
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. Note: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
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 = "MaBase"
Optim.File[1].Option = hOptStat
HAddScheduledOptimization(MyConnection, Optim)
Propiedades Properties specific to hFileParameter variables The following properties can be used to define the characteristics of hFileParameter variables: | | | | Property name | Type used | Effect |
|---|
| Name | Character string | Name of data file to be processed. This name can correspond to a string of the following type: - <Nom de la base>/<Nom du fichier de données>: Optimization of the "Data file name" file in the "Database 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 or Secret string | Password of the encrypted data files.
 Novedad versión 2025Cadenas secretas: Si utiliza el almacén de cadenas secretas, el tipo de cadena secreta utilizado para este parámetro debe ser "ANSI o Unicode string". Para obtener más información sobre las cadenas secretas y el almacén, consulte Almacén de cadenas secretas. This property is available in write mode. |
Observaciones Functions using hFileParameter variables | | | Réindexation Asynchrone (non bloquant du coté client) | | Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file). This new function is available from WINDEV Suite SaaS 2025 - Update 2. | | Checks the structural integrity of memos in an HFSQL Client/Server data file. This new function is available from WINDEV Suite SaaS 2025 - Update 2. | | Gets various statistics on the keys of an HFSQL Client/Server data file. This new function is available from WINDEV Suite SaaS 2025 - Update 2. |
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|