DBOpen Action

Opens a Recordset object belonging to an active connection.

Use

If the Recordset contains no records, both the BOF property and EOF property are set to True, and the current record position is undefined. You can still add new data to this empty Recordset object.

When you have concluded your operations over an open Recordset object, use the DBClose action to free any associated system resources.

Parameters

Recordset  -  (Required)

Specifies the name of the Recordset to be opened. The recordset will be referred to by this name in all subsequent DB actions. For example, your Recordset name might be "CustomerDetailsRS".

Connection  -  (Required)

Specifies the name of the Connection in which the recordset is to be opened.

Source  -  (Required)

Specifies the source of the recordset. For DDM data sources, this argument specifies the database file, and optionally the member. For ADO data sources, this argument is interpreted according to the value of the Command Type argument, described below. To specify the source as an expression, prefix the source with an equals (=) sign

Cursor Location  -  (Required)

Specifies the location of the cursor service for the recordset. Use one of the following pre-defined Cursor Location constants.

This argument is ignored for DDM data sources.  

Cursor Type  -  (Required)

Specifies the type of cursor to be used for the recordset. Use one of the following pre-defined Cursor Type constants.

This argument is ignored for DDM data sources.  

Lock Type  -  (Required)

Specifies the type of locks placed on records during editing. Use one of the following pre-defined Lock Type constants.  

This argument is ignored for DDM data sources.  

Command Type  -  (Required)

Specifies how the source argument should be interpreted. Use one of the following pre-defined Command Type constants.

This argument is ignored for DDM data sources.

Example

The following example connects to an Access database and uses the DBFind action to search the open recordset for a value saved in the variable varSearch. Connect DBConnect (testConnection, DBServerADO, Provider=Microsoft.Jet.OLEDB.4.0; Data Source=@test\crm.mdb; Mode=Share Deny None; Persist Security Info=False;) DBOpen (recordset1, testConnection, Table1, DBUseClient, DBOpenDynamic, DBLockReadOnly, DBCmdTable) Find DBMove (recordset1, DBMoveFirst) DBFind (recordset1, ="EntityRef = " & varSearch, DBFindForward) recordset1.EOF = False MsgBox(Found, =varSearch & " was found.", MsgInformation, MsgOKOnly) recordset1.EOF = True MsgBox(Not Found, =varSearch & " was not found.", MsgCritical, MsgOKOnly)   Close DBClose (recordset1) DBDisconnect (testConnection) StopMacro

See Also

DBConnect Action | DBDisconnect Action | DBOpen Action | DBClose Action | DBFind Action | DBMove Action | DBAddNew Action | DBBeginTrans Action | DBCancelUpdate Action | DBCommitTrans Action | DBDelete Action | DBRollbackTrans Action | DBSeek Action | DBUpdate Action

© 2004-2022 looksoftware. All rights reserved.