Re: [sqlite] Trying to INSERT rows into a table

2009-02-06 Thread Stephen Abbamonte
hy are you calling reset after step? regards, Adam On Fri, Feb 6, 2009 at 3:51 PM, Stephen Abbamonte <st...@tornadostudios.com> wrote: > Hi all I am using SQLite3 and running into a bit of a snag. I have a > Database with an empty table and I am calling a series of INSERT commands > d

[sqlite] Trying to INSERT rows into a table

2009-02-06 Thread Stephen Abbamonte
. Stephen Abbamonte Software Engineer Tornado Studios ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Journal files

2008-12-02 Thread Stephen Abbamonte
Okay I updated to version 3.6.6.2 and now I am only seeing "PRAGMA main.journal_mode = OFF;" not work with my custom defined OS ( when I switch to windows it works ) I should note that I changed sqlite3.c to sqlite3.cpp and got the amalgamation to compile in C++ I also defined SQLITE_OS_OTHER

Re: [sqlite] Journal files

2008-12-01 Thread Stephen Abbamonte
I just tried this line also and the journal files are still being created here is the code I am running: int32_t ret = sqlite3_open(filename, m_DatabaseRef); if( ret == SQLITE_OK ) { sqlite3_stmt* sqlStmt = NULL; ret =

Re: [sqlite] Journal files

2008-12-01 Thread Stephen Abbamonte
I tried that on sqlite3 version 3.6.6 and the return value was "OFF" but the journals are still being created. Any reason why this wouldn't work? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: Monday, December 01, 2008 9:56 AM To:

[sqlite] Journal files

2008-12-01 Thread Stephen Abbamonte
Hello all, I am looking for a way to completely turn off the creation of journal files. Any help is much appreciated. Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] PRAGMA journal_mode not working

2008-11-25 Thread Stephen Abbamonte
Hi all, I am running SQLite3 version 3.6.6 and I have successfully ported it to my OS. The problem I am seeing is that when I execute the command "PRAGMA journal_mode = OFF" it returns "OFF" but I am still seeing *.db-journal files being created. It is critical that these files