[sqlite] C++ Unresolved external errors from DLL

I'm trying to get SQLite working in my C++ project via a DLL, but Im getting unresolved external symbol errors. I downloaded SQLiteDLL-3 from the download page, extracted its contents (a DLL and a .h file), and ran lib.exe on it to produce a .lib file. I then set the directory containing the .lib

[sqlite] using SQLite with mod_perl

This is a perl question really, so apologies to the SQLite community. However, I am stuck, and I am flailing on various forums (perlmonks/stackoverflow), hoping to strike lucky. My problem is that I am running into the database locked error under mod_perl with Apache2. I thought I had surmounted

Re: [sqlite] using SQLite with mod_perl

On 9 Oct 2010, at 7:49am, P Kishor wrote: stuff My answers to these things are a little weird and I'm not sure I understand at all what you're doing. But it's a weekend so I'll answer anyway and let you correct me where I've misunderstood it. SELECT col1 FROM table WHERE condition;

Re: [sqlite] Porting SQLite 3.7.2 to vxWorks 6.7

Hello Scott, I did some searching with these symbols, they should be in 'libos.a'. rtpLib.o - rtpVerifyAndLock pgMgrLib.o - pgMgrPageFree, pgMgrPageAllocAt you should modify kernel components with your VIP project. Best Regards, Huang ZhiHua 2010/10/9 Scott A Mintz

Re: [sqlite] using SQLite with mod_perl

On Sat, Oct 9, 2010 at 6:24 AM, Simon Slavin slav...@bigfraud.org wrote: On 9 Oct 2010, at 7:49am, P Kishor wrote: stuff My answers to these things are a little weird and I'm not sure I understand at all what you're doing.  But it's a weekend so I'll answer anyway and let you correct me

[sqlite] Detach command in 3.7.1 gives database is locked error

This may be a bug in 3.7.1, or I may have been taking advantage of a flaw in 3.6.18: HashBackup uses SQLite to store backup data in a meta data db and file data archive db. First I open the main database, then attach an archive database. When the archive gets full, I detach it, create a new

Re: [sqlite] Confitional IF in triggers

Russell A slurc...@yahoo.com.au wrote: Hi Igor I'm converting an Interbase DB for use in a smaller application, so there are many different examples. I've included one particular example below, where I have converted a single Interbase trigger (which used IF statements), into 4 separate

[sqlite] Run Time Error #1 in VS2008

I am working on a project in VS2008 and I am including the sqlite3 code directly (compared to in the past using wrappers). The program is working great (accessing DB, using calls, etc) but I have hit a peculiar issue during runtime. I am getting an error from VS that is: Run-Time Check

[sqlite] composite foreign key

Hi, I am learning SQL. The following lines do not yield any error in SQLite. However, the foreign key in table ref_foo has four columns, and references table foo which has only 3 columns. Why is it possible? This is just a dummy example to understand what happens with composite foreign keys.

Re: [sqlite] Confitional IF in triggers

Thanks Igor - that's very helpful. --- On Sun, 10/10/10, Igor Tandetnik itandet...@mvps.org wrote: From: Igor Tandetnik itandet...@mvps.org Subject: Re: [sqlite] Confitional IF in triggers To: sqlite-users@sqlite.org Received: Sunday, 10 October, 2010, 2:46 AM Russell A slurc...@yahoo.com.au

[sqlite] RTREE still uses float

Is it intentional that RTREE code still uses 'float' types? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Create Read-only Database

I have a database that I want to be only read-only. I read in the optimization FAQ that this will make sqlite not create a journal and so run faster. I changed the permissions of my database file in Linux (removed the write permission), and sqlite was still able to create a new table. Since