HSetCache (Function)

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Management of databases

HFSQL functions

HFSQL Client/Server functions

HAddScheduledOptimization

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Functions for HFSQL Client/Server management

HSetCache (Function)

In french: HGèreCache

Available only with this kind of connection

Used to configure the management of caches in the HFSQL Client/Server engine.

Versions 17 and later

This function is now available for the iPhone/iPad applications.

New in version 17

This function is now available for the iPhone/iPad applications.

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Note: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available in Android Widget mode.

This function is now available for the Android applications.

This function is now available for the Java applications.

New in version 22

This function is now available in Android Widget mode.

This function is now available for the Android applications.

This function is now available for the Java applications.

This function is now available in Android Widget mode.

This function is now available for the Android applications.

This function is now available for the Java applications.

Example

HSetCache(hPageSize, 2000)

Syntax

<Result> = HSetCache(<Parameter to Modify> [, <File Name> [, <Item Name>]] , <Value>)

<Result>: Integer

Former value of modified parameter (value before modification).

<Parameter to Modify>: Constant

Parameter of the cache to modify:
hPageSize Size of a block of caches. This block of caches will be used when browsing a data file.
A large block of caches improves the browse and increases the transfers via network and the memory consumption.
This parameter corresponds to the number of records read during the browse.

<File Name>: Optional character string (with or without quotes)

Name of the data file to which the modification must be applied.
If this parameter is not specified, the modification is applied to all the data files.

<Item Name>: Optional character string (with or without quotes)

Name of the item to which the modification must be applied.
If this parameter is not specified, the modification will be applied to all the items found in the specified data file.

<Value>: Integer

New value that must be given to the parameter.
For the hPageSize constant, this value must be included between 1 and 5000 (the default value on a PC is 1000 and the default value on a Pocket PC is 10).

Component : wd240hf.dll