Re: [sqlite] interrupting sqlite3_prepare_v2

2008-06-01 Thread Daniel Önnerby
I have investigated futher and noticed that it will break when preparing statements like creating tables from a select. I filed a bugreport with example code at: http://www.sqlite.org/cvstrac/tktview?tn=3155 Dennis Cote wrote: > Daniel Önnerby wrote: > >> Sometimes this interrupt occur in the

[sqlite] SQLite Analyzer OSX

2008-06-01 Thread Bruce Robertson
I see that SQLite3 Analyzer for OSX is listed on the download page but no instructions are provided and when unzipped it does nothing. What are we supposed to do with this? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] reading a row that has been deleted

2008-06-01 Thread Keith Goodman
On Sun, Jun 1, 2008 at 2:19 PM, Alex Katebi <[EMAIL PROTECTED]> wrote: > Hi All, > > I have a in-memory database with some tables. Each table has a single > record writer and multiple readers. > Readers and writes prepare their own sqlite3_stmt for the db. Everyone > operates within a single thre

[sqlite] reading a row that has been deleted

2008-06-01 Thread Alex Katebi
Hi All, I have a in-memory database with some tables. Each table has a single record writer and multiple readers. Readers and writes prepare their own sqlite3_stmt for the db. Everyone operates within a single thread. What happens if a reader wants to read a record that has been deleted by the

Re: [sqlite] Saving an in-memory database to file

2008-06-01 Thread Bruce Robertson
>> On Sat, May 31, 2008 at 9:48 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote: >>> Here's a more basic example. This is really just a shell script formatting >>> problem and it must be really simple. I'm trying to use \n as new line. The >>> result I want from the echo statement is as follows but I

Re: [sqlite] Saving an in-memory database to file

2008-06-01 Thread Bruce Robertson
> On Sat, May 31, 2008 at 9:48 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote: >> Here's a more basic example. This is really just a shell script formatting >> problem and it must be really simple. I'm trying to use \n as new line. The >> result I want from the echo statement is as follows but I can