ADO Command

by Linda Quinn

Close Window

Create a command object to update, add and delete records

Dim rcmd As ADODB.Command
Set rcmd = New Command
rcmd.ActiveConnection = gConn
rcmd.CommandType = adCmdText


Execute a command
rcmd.CommandText = strsql
rcmd.Execute


The value of STRSQL can be any query that updates, adds and deletes records.


=================================================================
This content was created by Linda Quinn of LQNet.

See http://www.lqnet.com for a great collection of articles on this and other topics.

=================================================================
Copyright © 2006-2008, LQ Systems,Inc. All rights reserved.


====================================================================
Want an expert to help with your project?    LQ Systems, Inc.   Business Solutions
====================================================================