Re: [sqlite] Last call for bugs...

2007-01-26 Thread Jason Jobe
How about including using FullTextSearch as a config / make option? FTS Still not working on OSX (for me). -jason On Jan 26, 2007, at 2:33 PM, [EMAIL PROTECTED] wrote: I plan to release 3.3.12 later today or tomorrow. If you know about any unreported problems, please get those bug reports in

[sqlite] building in fts[12] on OSX

2007-01-25 Thread Jason Jobe
Hello, I just downloaded the latest version (3.3.11). It configures and build fine out-of-the-box on OSX (10.4.8) BUT I can't seem to get the Full Text Search extension working and / or linked into the library / sqlite shell. I tried adding the suggested flags in the Makefile to no

Re: [sqlite] Callback when table contents have changed

2005-04-19 Thread Jason Jobe
Using a trigger is exactly what I have done. It works great and you get to easily control the parameters of event. Just register your user-defined function and create a trigger thusly. create trigger log_report after insert on logEvent for each row begin select appLogCallback

[sqlite] using cross-link table

2005-03-26 Thread Jason Jobe
I'm a big fan of EOF (Apple's relational to OO tool) and I've been trying to figure out the easiest/best way to support queries that span several links through a many-to-many cross-link table and am hoping for some suggestions and pointers. Here is the kind of query I would like to write (or

Re: [sqlite] debugging a locking problem

2005-01-30 Thread Jason Jobe
PM, Ulrik Petersen wrote: Jason Jobe wrote: I did find some where I wasn't doing that but I think I got them all. Sometimes I use sqlite3_exec; other times, when I need to get the rows I use sqlite3_step (with the finalize). Then perhaps you are calling sqlite3_exec in between an sqlite3_ste

Re: [sqlite] debugging a locking problem

2005-01-30 Thread Jason Jobe
as the in-memory version; same results. On Jan 30, 2005, at 8:10 PM, D. Richard Hipp wrote: On Sun, 2005-01-30 at 19:56 -0500, Jason Jobe wrote: Hey out there. I'm having a dickens of a time trying to debug a locking issue. I thought I was doing something simple enough; accessing a database from within one

[sqlite] debugging a locking problem

2005-01-30 Thread Jason Jobe
Hey out there. I'm having a dickens of a time trying to debug a locking issue. I thought I was doing something simple enough; accessing a database from within one process with no threading. 2005-01-30 19:28:10.736[5716] sqlite:ERROR database table is locked Trying again I get 2005-01-30