Re: [sqlite] OT: General SQL Question

2005-05-01 Thread Dan Keeley
post the table structures and index / keys and I'll help - Original Message - From: "Dan Keeley" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Saturday, April 30, 2005 6:38 AM Subject: [sqlite] OT: General SQL Question Hi, I know this isnt related to SQLite, h

Re: [sqlite] OT: General SQL Question

2005-04-30 Thread Dan Keeley
SQL Question Date: Sat, 30 Apr 2005 07:16:55 -0400 It is possible depending on the make up of the tables. post the table structures and index / keys and I'll help - Original Message - From: "Dan Keeley" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Saturday,

[sqlite] OT: General SQL Question

2005-04-30 Thread Dan Keeley
Hi, I know this isnt related to SQLite, however i dont really know where else to ask. I have 3 tables - Supplier, Audits and Audititems. At the moment, i select and join audits and Audititems and it works great. However i need fields from the supplier chain, so i effectively need to do a 3

Re: [sqlite] Proposal: limit the number of columns in a table to 2000.

2005-03-17 Thread Dan Keeley
It's rarely a good idea to use binary numbers for limits such as that - you're exposing yourself to more corner case bugs. Interesting issue... I thing that we may use 2048 instead 2000. It´s an number more "binary". I think that it´s sufficient to 99.99% of the possible applications. That´s a

Re: [sqlite] speedtest result is obsolete

2005-02-09 Thread Dan Keeley
I think you people are missing the point here, the performance increase you're seeing is all down to OS caching and will vary across different ports. It's nothing to do with sqlite, and will affect every package. Therefore the only way to fairly compare mysql/postgress/sqlite is to make sure

RE: [sqlite] SQLite Advocacy

2005-01-31 Thread Dan Keeley
3. SQLite is much faster than SQL Server 7. I'm sorry but you simply cannot state that. Sure, it's faster in some circumstances, but there are situations where SQL Server 7 would definately be faster. And if you're in that situation, then you probably want advanced features such as replication

Re: [sqlite] ODBC Driver

2004-12-23 Thread Dan Keeley
The page that gives the (very impressive) list of drivers and wrappers for SQLite is: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers The specific one you want is: http://www.ch-werner.de/sqliteodbc/ Excellent thanks! Rgds, Dan

Re: [sqlite] ODBC Driver

2004-12-23 Thread Dan Keeley
Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [sqlite] ODBC Driver Date: Thu, 23 Dec 2004 00:15:46 +0100 Dan Keeley wrote: Hi, I've finally got round to building sqlite. Now i'm after the odbc driver for it. Only thing is I can't seem to find the page on the sqlite website that lists

[sqlite] ODBC Driver

2004-12-22 Thread Dan Keeley
Hi, I've finally got round to building sqlite. Now i'm after the odbc driver for it. Only thing is I can't seem to find the page on the sqlite website that lists other programs, such as an odbc driver for use with sqlite? Is there a recommended odbc driver to use? Rgds, Dan

Re: [sqlite] Join function in select statement

2004-11-02 Thread Dan Keeley
Loading shared libraries is easy enough on windows and Linux, but throw AIX and HPUX and Solaris into the mix and suddenly things become more complicated. SQLite is a cross-platform library. It has to work on more than just windows. Really? Both these platforms support shared libraries - I use

Re: [sqlite] OT: Reply-To Munging Considered Useful

2004-07-23 Thread Dan Keeley
Or, why dont we have a vote, and once it's decided, tuff luck thats how it stays? :) _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger

Re: [sqlite] OT: Reply-To Munging Considered Useful

2004-07-23 Thread Dan Keeley
> If you put an Reply-To Header in the mail, you make this options > disfunctional. Now, both buttons do the same thing, they don't work as > expected. > > Freedom is all about choice. Reply-To tries to disable the choice. Not > very friendly, in my opinion. > > Please switch off Reply-To again. >