[sqlite] BEGIN TRANSACTION / COMMIT errors

2006-10-05 Thread Levi Wilson
I have a process that opens up a connection to my database when it starts up with sqlite3_open. This connection is kept for the life of the process. In one of my functions, it inserts a row into one table, and also into another table that is related. Therefore, I wrap both statements within a

Re: [sqlite] opening a database in command prompt in Windows

2006-08-21 Thread Levi Wilson
You may want to download the SQL Lite Database project from sourceforge. On 8/21/06, John Salerno <[EMAIL PROTECTED]> wrote: I downloaded the command line utility, and it is an exe file that automatically opens the sqlite prompt. Given this, how am I supposed to open or create databases? The