DBDisconnect Action

Disconnects from a data source.

Use

The DBDisconnect action also closes any active Recordset objects associated with the connection. Disconnecting while a transaction is in progress generates an error.

Parameters

Connection  -  (Required)

Specifies the name of the Connection object to be disconnected.

ClosedExample

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.