UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> Recordset    
Recordset

Recordset

Definition: A construct that can contain zero, one, or many records.

The most common source of data for a recordset is a single table. However, it may contain information from various fields gathered from multiple tables, ... even multiple databases or other sources. It's source of data need not be table at all, but can be populated manually, if need be.

Other than SQL, it is the most common way for a developer to interact with data. A recordset can be bound to a form or report, or manipulated programmatically.

Recordsets also have a number of properties that characterize the features of a particular recordset. These properties control things like whether it is read-only, whether movement through the recordset is forward-only or bi-directional, record locking strategies, and the scope of the data that the recordet is aware of. Under most circumstances these properties are defined before the recordset is opened.

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 3,596 times.  This page was last modified 02:28, 21 July 2012 by Walter Niesz.   Disclaimers