How to validate an INSERT, after Executing

[VBExplorer12]

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?

[digitalShaman]

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.

[VBExplorer12]

Thanks digital,

That's what I needed.

Regards,