How to validate an INSERT, after Executing

Hi,

I have

Code:

---

Set cn = CreateObject( "ADODB.Connection" )
cn.Open "Driver={SQLite3 ODBC Driver};Database=c:\XXXXXXXX\XXXXXX\XXL_XX\MYPRODDB.db;"

---

, and it connects fine, and runs queries.


The INSERT is executing fine as well, based on a query from my sql tool afterwards.

Code:

---

THISTABLE_ins = "INSERT INTO [THISTABLE] SELECT * FROM [THATTRANSACTIONTABLE] WHERE  [Filename] = " & "'" & THISFileName_s & "'" & " AND [status] = 'F'"
cn.Execute( THISTABLE_ins )

---

, but my question is, how can we validate that the INSERT works from the cn object, immediately after executing? Do we need to do a query, or is there some property of the cn variable that we can poll?

cn.execute can return the number of rows affected in a second parameter.
see here: https://stackoverflow.com/questions/...ba-ado-execute

This should be >0 in your case and you should be able to check for that.
On the other hand, a failed .execute usually results in a RTE as well, so no error but rows affected = 0 would mean that the SQL Statement completed but no records were inserted.

Thanks digital,

That's what I needed.

Regards,

Quote:

---

Originally Posted by VBExplorer12

Code:

---

Set cn = CreateObject( "ADODB.Connection" )
cn.Open "Driver={SQLite3 ODBC Driver};Database=c:\XXXXXXXX\XXXXXX\XXL_XX\MYPRODDB.db;"

---

---

If you don't mind my asking, where did you get the SQLite3 ODBC Driver?

I get the following runtime error:

Quote:

---

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

---

I'm trying this with VBA/Excel.

https://www.ch-werner.de/sqliteodbc/

Quote:

---

Originally Posted by VBAhack

If you don't mind my asking, where did you get the SQLite3 ODBC Driver?

I get the following runtime error:



I'm trying this with VBA/Excel.

---