Contents | Prev | Next

4.2.48 rsstatic

Description

rsstatic is used when opening a recordset (see recordset.open) to specify that a static recordset should be opened. Static recordsets are scrollable (i.e. you can move both forwards and backwards through the records in the recordset). Database changes (e.g. record inserts, updates, and deletions) are not visible to static recordsets after the recordset is opened. NOTE: Irie Pascal does not currently provide a way to move backwards through a recordset, so you can not take full advantage of static recordsets. Also if the database is MySQL then this constant is ignored and a forward-only recordset is opened instead.

Example

   rs.open(conn, sSQL, rsstatic);

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.

   rsstatic specifies that a static recordset should be opened.

Portability

Operating Systems: All
Standard Pascal: No

Contents | Prev | Next