how do I execute an SQL update

[email protected] · June 22nd, 2003, 04:46 AM

Hi, how do I execute an update statement in code similar to,

UPDATE mvpr SET stock = three

Jeff Mason · June 22nd, 2003, 06:50 AM

There are several ways. Assuming you are using ADO, probably the simplest is to use the Execute method of the connection object:

Code:

Dim Sql as string
Sql="UPDATE mvpr SET stock = three"
MyConn.Execute Sql, , adCmdText Or adExecuteNoRecords

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com