Promotic
WikipediaLinkedInYoutubeTwitterFacebook

SetParam - method of object PmDatabase

Description:
Setting parameters of the PmDatabase object.
Syntax:
SetParam(sType As String, vParam As Variant)
Calling:
oDb.SetParam sType, vParam
Parameters:
sType(String) Type of the set parameter.
"lockingmode" - Setting the method for locking the rows on editing, i.e. calling the methods Edit, FieldValues, Update. In this case the vParam parameter is of the Boolean type.

If the vParam parameter is set to true, then the data block of the size 2KByte and containing the row on the current position is locked already when calling the Edit method (if this block was locked before by another user, then an error would be announced).

If the vParam parameter is set to false, then the data block of the size 2KByte and containing the row on the current position is locked only after calling the Update method (if this block was locked before by another user, then an error would be announced).

"logintimeout" - Setting the time interval (timeout) to connect to the database in the ODBC mode (see the configurator "Technology"), i.e. the method Connect or Open will wait for vParam seconds at least if the connection to the database succeeds. Setting is shown only on the next connection to the database (i.e. after the disconnection of the database). The preset value is 20 sec.
"querytimeout" - Setting the time interval (timeout) to perform a query or a statement in the ODBC mode (see the configurator "Technology"), i.e., for example, the Open method will wait for vParam seconds at least before the query to data of the Table (file) table or the SQL statement SQL statement is performed. The method with this parameter must be called before performing the command itself, i.e., for example, before calling the method Execute, ExecuteSQL or Open. The preset value is 20 sec.
vParam(Variant) Value of the parameter is dependent on sType.
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice