Omron CX-Supervisor Reference Manual

Database Commands SECTION 6 Functions and Methods
108
6-17-7 DBOpen
Description
Opens a Connection or Recordset. Opening a Connection will automatically
open all recordsets associated with it, that are marked as auto open.
Recordsets can be opened in isolation by selecting the appropriate level.
Syntax
returnstate = DBOpen(level)
Remarks
Typical Examples
DBOpen("Northwind")
Open the connection to the Northwind database, and automatically open any
Recordsets set to open on connection.
done = DBOpen("Northwind.Order Details")
Just open a specific Recordset.
6-17-8 DBProperty
Description
Returns the requested property. This function operates on the Recordset and
Field levels. The type of the value returned depends on the property
requested.
Syntax
returnstate = DBProperty(level, property)
Remarks
Note: Some Providers do not support moving in the "Previous" direction i.e. cursors
are 'Forward-Only'. Some 'Forward-Only' providers do allow moving "First",
while some are strictly Forward-Only i.e. the Recordset has to be Re-queried
effectively a combined Close then Open operation to reset the cursor back to
the start of the Recordset. Some Providers that do support moving "Previous"
do not support moving to "Position". However, in order to be consistent, CX-
Supervisor ensures that that all operations (except "Bookmarks") will work for
any connection to any provider but you need to bear in mind when designing
applications that use 'Forward-Only' cursors, that there may be some 'long-
winded' acrobatics being performed behind the scenes. See DBSupports() for
details of how to check the type of cursor in force.
Note: Bookmarks will only work if specifically supported by the Provider.
Argument Type Description
returnstate bool 1 if the function is successful otherwise 0
level text A text point or constant specifying the
connection level. This must be a Recordset
level.
Argument Type Description
returnstate bool 1 if the function is successful otherwise 0
level text A text point or constant specifying the
connection level. This must be a Recordset
level.

Omron CX-Supervisor Specifications

General

Brand	Omron
Model	CX-Supervisor
Category	Software
Language	English