ADO Recordsets are Forward Only By Default
Written by Eric Smith, Northstar Computer Systems LLC
If you’re using ADO Recordsets in your applications, remember that using the Connection.Execute method creates a Forward-Only recordset. This type of recordset can only be used with the MoveNext statement. If you need to move back and forth through the recordset, you need to create a recordset and use its Open method to retrieve the data. Be sure to specify a recordset type other than forward only when you do this or you’ll end up with the same problem. Forward-only recordsets are the most efficient type for rapidly moving through data to load into another control, for instance, but if you need to move around, you do have other options.
Keywords: [
Active Data Objects
]
Publication Date: 7/17/2000, Last Update: 2/12/2010
|