Promotic

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, WriteFieldValue, 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 2K bytes 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 2K bytes and containing the row on the current position is locked only when calling the Update method (if this block was locked before by another user, then an error would be announced).
"logintimeout" - Setting the time span (timeout) for connection 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 span (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.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.