[sqlite] ON INSERT trigger

2004-09-19 Thread Alex
Hi, In my project I have two databases: primary which is an SQLite db, and secondary which is based on a different engine. A table in the primary db contains values which are keys for the secondary db. To maintain coherence of the two databases I use SQLite triggers. The DELETE and UPDATE

[sqlite] Both libraries, some more troubles...

2004-09-19 Thread Marco Bambini
Hi, thanks for your past replies, I am now using the latest 3.0.7. I think that there are two more problems when using both libraries in the same project. Two redefined macros (with different values) that most compilers treats as an error: sqlite.h: #define SQLITE_VERSION "2.8.15"

Re: [sqlite] Help please

2004-09-19 Thread Tito Ciuro
On Sep 19, 2004, at 09:46, EzTools Support wrote: There was a definition for MAX_BYTES_PER_ROW. I cannot find it anymore in 3.0.7. Is there still such a concept as maximum row size? http://www.mail-archive.com/[EMAIL PROTECTED]/msg03325.html -- Tito

[sqlite] Help please

2004-09-19 Thread EzTools Support
There was a definition for MAX_BYTES_PER_ROW. I cannot find it anymore in 3.0.7. Is there still such a concept as maximum row size? TIA -Brett Goodman

[sqlite] *** Please help ***

2004-09-19 Thread EzTools Support
Hello. Can someone please help with this issue. It may turn out to be a bug in Sqlite 3. I have the following fairly basic SQL View that works fine with Sqlite 2.x: CREATE VIEW Invoices AS SELECT Customers.CustomerID, Customers.CompanyName,Orders.OrderID, OrderDetails.ProductID,

Re: [sqlite] I need a SQLite3 Wrapper for Java.

2004-09-19 Thread Christian Werner
"[EMAIL PROTECTED]" wrote: > > Hello, > > and yes I do. I've tried to port, but without success. Please try out http://www.ch-werner.de/javasqlite/javasqlite-20040919.tar.gz Right now (since 3.0.7 is out, big thank you to DRH!) it somewhat began to work on Linux. As usual