Vance E. Neff <ven...@intouchmi.com> wrote: > I'm having trouble on the "COMMIT TRANSACTION" Query. > > I seem, for some reason, to be violating a SQLite rule. > > This is from a language called RUN BASIC. > > Here is the test program, note that "" translates to a single " and > the print statements are just for this demo: > > #SQLiteDataBase EXECUTE( "SELECT MAX( ShoppingListIndex ) AS > MaxShoppingListIndex FROM ShoppingLists" ) > PRINT "Executed select max" > #CurrentQueryRow = #SQLiteDataBase #NEXTROW() > > #SQLiteDataBase EXECUTE( "COMMIT TRANSACTION" )
Before you can commit a transaction, you need to close all outstanding select statements. Figure out how to do the equivalent of sqlite3_reset or sqlite3_finalize in your programming language. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
