Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to validate an INSERT, after Executing

Status
Not open for further replies.

Don Child

Programmer
Apr 4, 2003
63
2
8
US
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?


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top