The
ADO Recordset object represents a set of records. It is an object implemented from the
ADO technology by the
Microsoft company. Only the most important properties and methods will be described in the PROMOTIC documentation. The exact description of the see object interface
http://msdn.microsoft.com/en-us/library/ms681510(v=VS.85).aspx or
http://www.w3schools.com/asp/ado_ref_recordset.asp.
The ADO Recordset object: The
AdoRecordset object represents the resulting data of
SQL query. The data may consist of arbitrary number of records, where each record of the corresponding
AdoRecordset object has the same structure (
AdoField objects). The data are represented by a table, where each record corresponds to a row and the columns consist of the
AdoField objects.
Current record: One of the records can be selected as current record. It is the one record that is currently being worked with. A wide set of operations refer to the current record. In order to move the current record cursor within the
AdoRecordset object many methods can be used, for example
MoveFirst,
MoveNext, etc. There can be only one selected current record in the
AdoRecordset object, or there can be none. When moving through the records one by one (forward or backward), forward by the
MoveNext method (or backward by the
MovePrevious method), finaly the selected current record will get to the position of last (first) record and the move ends there. The
EOF property (
BOF) serves for indicating that the cursor reached the end (beginning) of the recordset.
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.