cmd.ExecuteNonQuery IN VBA FOR EXCEL

[sal21]

I can use this statement cmd.ExecuteNonQuery in a CMD to exceute a SQL?

Or i can integrate in CMD

this CMD.Execute SQL, , adCmdText + adExecuteNoRecords

????

[HansV]

ExecuteNonQuery is valid in VB.NET. It won't work in VBA for Excel.

If you create an ADO Command object CMD, you can use

CMD.Execute SQL, , adCmdText + adExecuteNoRecords

[sal21]

ExecuteNonQuery is valid in VB.NET. It won't work in VBA for Excel.

If you create an ADO Command object CMD, you can use

CMD.Execute SQL, , adCmdText + adExecuteNoRecords

OK TKS!

but if i put into , , my long variable LNG after the execution have LNG=0!!!!!

i'm sure the query update a records, sure!

is the parameter , , the count of record affect? or not?

[HansV]

Oh wait - it doesn't work this way with a Command object, but with a Connection object.

[sal21]

Oh wait - it doesn't work this way with a Command object, but with a Connection object.

yes, only with Command object...(?)

instead with the tipical:

SQL = "INSERT INTO ....."
CONN.Execute SQL, LNG, 129

work perfect and return the correct number of recordset found!

[HansV]

With a command object, you could use

CMD.CommandText = SQL
CMD.Execute LNG, , adCmdText + adExecuteNoRecords

[sal21]

With a command object, you could use

CMD.CommandText = SQL
CMD.Execute LNG, , adCmdText + adExecuteNoRecords

Ahhhh ....

But Not between , , but near execute stattement
Taths si news for me...
Tks.

[HansV]

The syntax of the Execute method of the Connection object is:

connection.Execute CommandText, RecordsAffected, Options

And the syntax of the Execute method of the Command object is:

command.Execute RecordsAffected, Parameters, Options

Notice that RecordsAffected is the second argument of connection.Execute, but the first argument of command.Execute.

See:
Execute Method (ADO Connection)
Execute Method (ADO Command)