I am converting a program from VB3 to VB6. In the original code, Set AppSN1 = AppDB.CreateSnapshot(SQLStmt$, DB_SQLPASSTHROUGH)where SQLStmt$ = 'delFileCond 'L'{CRLF}go{CRLF}insFileCond 'L', 'Reissue fee due', it works fine. In VB6, where I use cnConnect.Execute SQLStmt$, dbFailOnError, it fails. I ran SQL Trace and find that in VB6 not only do I get the two stored procedures that I am expecting, I also get, after the stored procedures have run, this SQL: select * from delFileCond 'L'{CRLF}go{CRLF}insFileCond 'L', 'Reissue fee due'. "select * from" is appended to the front of the SQL I sent and submitted again, for some reason. It appears to be the contents of a cache and it's reproducable. The same additional SQL attempts to execute every time I try. I'm not sending the additional statements.
Can anyone suggest a place to look here? Is it the way I'm doing the execute?