UPDATE and INSERT SQL questions

[cedx]

Hi,

How do I use UPDATE and INSERT type SQL statements in a database and recordset declared in code?

I use the following for SELECT statements:


SQL = "SELECT * FROM Employees"
Set db = OpenRecordset(dbPath)
Set rs = db.OpenRecordset(SQL)


I can't seems to get rs.Execute(SQL) to work. What am I doing wrong?

Thanks in advance.

[Nina]

StrSQL = "INSERT INTO " & Table_Name & _
" (" & StrFields & ") " & _
" VALUES (" & StrValues & ")"
'Debug.Print StrSQL

Dim cmd as ADODB.Command
Set cmd = New ADODB.Command
cmd.ActiveConnection = cnDB
cmd.CommandText = StrSQL
cmd.Execute
Set cmd = Nothing

[cedx]

Thanks Nina.

[honeybee]

I do it in DAO as this:


SQL = "Update ......"
dbMaster.Execute SQL


If you are not getting this right, maybe you are using parenthesis around the query, like:


SQL = "Update ...."
dbMaster.Execute(SQL)


Try omitting the parenthesis and it should work.