RsIsOpen - method of object PmAdo

Testing the existence of the AdoRecordset object with defined identifier.
RsIsOpen(sId As String) As Boolean
b = oDb.RsIsOpen(sId)
sId(String) The unique identifier that is used by the PmAdo object to store the AdoRecordset object.
Return Values:
true - Object AdoRecordset with defined identifier exists (e.g. by calling the methods RsOpen or DbExecute).
false - Object AdoRecordset object with defined identifier doesn't exist. It means that it was not opened or it was already closed by calling the RsClose method.
ADO Record object:

Depending on the specific ADO Provider it is possible, that a single row SQL query result will not be returned as AdoRecordset object containing a single record, but as a AdoRecord object (represents the single row). Není to ale typické pro nejběžněji užívané ADO Provider. 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, similar as the AdoRecordset object. The difference is that the methods for moving the position of current record are not supported (e.g. MoveFirst). In order to keep the documntation simple, it will be referred only to the commonly returned object AdoRecordset, although in some special cases the system may also return the AdoRecord object.

See also:
Testing whether the PmAdo object ("/TestAdoDb") contains the stored AdoRecordset object with unique identifier ("table1").
VBScriptSelect and copy to clipboard

Dim oDb
Set oDb = pMe.Pm("/TestAdoDb")
If oDb.RsIsOpen("table1") Then
End If
PROMOTIC 8.3.30 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