Promotic
WikipediaLinkedInYoutubeTwitterFacebook

SetParam - method of the PmaDatabase object

Description:
Sets parameters of the PmaDatabase object.
Syntax:
Empty SetParam(String sType, Variant 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 "Technology" configurator), i.e. the Connect method 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 default value is 20 sec.
"querytimeout" - Setting the time interval (timeout) to perform a query or a statement in the ODBC mode (see the "Technology" configurator), 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 during opening SQL statement is performed. The method with this parameter it is necessary to call before performing the command itself, i.e. for example, before calling the method Execute, ExecuteSQL or Open. The default value is 20 sec.
vParam(Variant) Value is dependent on the sType parameter.
Example:
JavaScriptVBScriptSelect and copy to clipboard

oDb.SetParam("logintimeout", 15);
PROMOTIC 9.0.13 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice