rskeyset

Description

rskeyset is used when opening a recordset (see recordset.open) to specify that a keyset recordset should be opened. Keyset recordsets are scrollable (i.e. you can move both forwards and backwards through the records in the recordset). Some database changes (e.g. record updates) are visible to keyset recordsets after the recordset is opened, but others (e.g. record insertions and deletions) are not. NOTE: Irie Pascal does not currently support keyset recordsets, if you specify this constant then a dynamic recordset is opened instead, unless the database is MySQL in which case a forward-only recordset is opened.

Example

   rs.open(conn, sSQL, rskeyset);

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.

   rskeyset specifies that a keyset recordset should be opened.

Portability

Operating Systems: All
Standard Pascal: No