Promotic

RsIsOpen - method of the PmaAdo object

Description:
Test the existence of the AdoRecordset object with the specified identifier.
Syntax:
Boolean RsIsOpen(String sId)
Parameters:
sId(String) The unique identifier that is used by the PmaAdo object to store the AdoRecordset object.
Return value:
true - The AdoRecordset object with the specified identifier exists (e.g. by calling the methods RsOpen or DbExecute).
false - The AdoRecordset object with the specified identifier does not exist. It means that it was not opened or it was already closed by calling the RsClose method.
Note:
The ADO Record object:
Depending on the specific ADO Provider it is possible, that a single row SQL query result will not be returned in the form of the AdoRecordset object containing a single record, but in the form of the AdoRecord object (represents the single row). However, this is not typical of the most commonly used ADO Providers. The AdoRecord object is usually returned by explicit operations, when the specific AdoRecord is returned from the existing AdoRecordset object. The AdoRecord object consists of multiple AdoField objects, the same way as the AdoRecordset object. The difference is that the methods for moving the current record position are not supported (e.g. MoveFirst).
In order to keep the documentation PROMOTIC simple, it will be referred only to the commonly returned AdoRecordset object, although in some special cases the system may also return the AdoRecord object.
See also:
- PmaAdo.RsOpen (method)
- PmaAdo.RsGet (method)
- PmaAdo.RsClose (method)
- PmaAdo.DbExecute (method)
Example:
Test whether the PmaAdo object ("/TestAdoDb") contains the stored AdoRecordset object with unique identifier ("table1").
JavaScriptVBScriptSelect and copy to clipboard

var oDb = pMe.Pm("/TestAdoDb");
if (oDb.RsIsOpen("table1"))
{
// ...
}
History:
Pm8.01.00: Created
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

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