rsforward is used when opening a recordset (see to specify that a forward-only recordset should be opened. Forward-only recordsets, as the name suggests, only allow you to move forwards. To return to previous record your program would have to close the recordset, reopen it, and skip to the record you are interested in. Database changes (i.e. record insertions, updates, or deletions) are not visible to forward-only recordsets after the recordset is opened.

Example, sSQL, rsforward);

In the example above

   rs is the recordset object that will contain the opened recordset.

   conn is the connection object containing an open connection to a database.

   sSQL is a string variable containing the SQL statement that defines the recordset.

   rsforward specifies that a forward-only recordset should be opened.


Operating Systems: All
Standard Pascal: No