Re: [sqlite] want to purchase

__ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Cheers. -- Dr Gerard Hammond http://www.macsos.com.au The Macintosh may only have 10% of the market, but it is clearly the top 10%.

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

ie they should come out y 9 1 That's what (2) says to me Cheers. -- Dr Gerard Hammond http://www.macsos.com.au Cheers. -- Dr Gerard Hammond http://www.macsos.com.au Cheers. -- Dr Gerard Hammond Garvan Institute of Medical Research

Re: [sqlite] UNION and ORDER BY errors starting from sqlite 3.4.2

2(b); select t1.a from t1 union all select t2.b from t2 order by a; SQL error: ORDER BY term number 1 does not match any result column Cheers. -- Dr Gerard Hammond Garvan Institute of Medical Research - To

Re: [sqlite] Transaction Check

s, Dr Gerard Hammond MacSOS Solutions Pty Ltd [EMAIL PROTECTED] http://www.macsos.com.au Proofread carefully to see if you any words out. - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] v2 and v3 differences - Help with some SQL

, Dr Gerard Hammond We are on the cutting edge of catching up. - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Re: suggest an index to make this faster

Thanks You Igor. As the PRIMARY KEY of the table Category is CategoryID, is it necessary to specifically create an index of a primary key? At 11:21 PM -0400 21/4/07, Igor Tandetnik wrote: Dr Gerard Hammond wrote: Could somebody suggest an index(es) I could add to my sqlite v3 (REAL SQL

[sqlite] suggest an index to make this faster

'False', HasSplitTrans boolean DEFAULT 'False', Currency varchar(10) DEFAULT 'AUD', CurrConverter float DEFAULT '1.00', ForeignCurrencyAmount double DEFAULT '0', locked boolean DEFAULT 'false', PRIMARY KEY(TransID)); TIA -- Cheers, Dr Gerard Hammond MacSOS Solutions Pty Ltd [EMAIL PROTECTED

[sqlite] Size of INDEX in database

Hi, Is there a SELECT call I can issue to the SQLite engine to determine the number of bytes that INDEXs occupy. -- Cheers, Dr Gerard Hammond PowerPC Mac the world's most advanced obsolete computer

[sqlite] Stop multiple simultaneous users

Hi, How can I stop multiple simultaneous users accessing a SQLite database? Is there a SQLite function that tells me how many people/applications have the database open? I am using REALbasic on a OSX, Win32 and Linux. -- Cheers, Dr Gerard Hammond MacSOS Solutions Pty Ltd, 505/176 Glenmore Rd

[sqlite] Date Difference - How do I subtract two dates

Hi, How do I subtract two dates and get the answer in minutes? -- Cheers, Dr Gerard Hammond Bioinformatic Analyst Garvan Institute of Medical Research, Sydney, Australia. If you're not part of the solution, you're part of the precipitate.

Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

exe, hlp and sqlite3 dll. hope you'll look into the help as well. Here is an image: http://www.hellobasic.com/images/pbsdbms.jpg Thanks! Does it run under MacOS X. If so, then I'd be happy to test. -- Cheers, Dr Gerard Hammond Bioinformatic Analyst Garvan Institute of Medical Research, Sydney