OpenRecordset(active)
Returns the Recordset object that represents a recordset containing all records of GDB table or external table. The created object is added to the GeoDatabase::Recordsets collection in the case of GDB table and to the ExternalDatabase::Recordsets collection in the case of external table. A name and an internal number are assigned to the object. The object name is based on the table name with possible numerical suffix.
The optional logical argument specifies the initial state of the recordset. If the active argument is True, the recordset is in the active state. The active state means that you can position records in the recordset, access, add, modify, and remove records. If the active argument is False, the recordset is in the passive state. The passive state means that you only can add records of the recordset to a table of GDB or external database using the Recordset::Update method and remove all records of the recordset from a table of GDB or external database using the Recordset::Clean method. To change the recordset state from passive to active, use the Recordset::Refresh method and from active to passive – the Recordset:Deactivate method. Use the Recordset::IsActive property to determine the recordset state.
The recordset creation time is less in the passive state than in the active one. Besides, a recordset in the passive state consumes less system resources on both the server side (in case of external database) as well as on the client side. If an application performs adding records or removing all records of the recordset, it is recommended to create a recordset in the passive state. The default value of the state argument is True (the recordset is in the active state).
 |  |
