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?