How to validate an INSERT, after Executing

[Don Child]

Hi,

I have

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.

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?

 

[Don Child]

In case anyone needs this in the future, someone answered this in another forum. They pointed to

https://stackoverflow.com/questions/12676747/how-to-get-the-affected-rows-in-vba-ado-execute

as an example of how to get the number of rows affected by the INSERT.


This answer, from the forum here, is even more specific:

https://www.tek-tips.com/viewthread.cfm?qid=739642