Re: [sqlite] Releases?

2011-02-26 Thread Vannus
http://www.sqlite.org/download.html maybe you want the windows/linux pre-compiled libs on that page? On 26 February 2011 16:51, Clay Fowler paul.clay.fow...@gmail.com wrote: Where and how do we download releases? The site at http://system.data.sqlite.org/ leads me eventually to open and closed

Re: [sqlite] Question about having 2 db connections on same thread

2011-02-13 Thread Vannus
Are you not able to use the same db connection in both classes? something like FirstTablesClass-dbConnection = MyDBConnectionClass SecondTablesClass-dbConnection = MyDBConnectionClass On 13 February 2011 23:04, jeff archer jarch...@yahoo.com wrote: I thought this would be OK but now that I am

Re: [sqlite] determine SQLITE_MAX_LENGTH or sql_limit/sqlite3_limit

2011-02-10 Thread Vannus
That should do the trick, thanks for pointing it out. On 10 February 2011 06:18, Dan Kennedy danielk1...@gmail.com wrote: On 02/10/2011 01:56 AM, Vannus wrote: Zeoslib is reading sqlite field lengths incorrectly, as it checks for brackets after the field typename ie. CHAR(123) presumably

[sqlite] determine SQLITE_MAX_LENGTH or sql_limit/sqlite3_limit

2011-02-09 Thread Vannus
Zeoslib is reading sqlite field lengths incorrectly, as it checks for brackets after the field typename ie. CHAR(123) presumably this is only affecting me because I haven't defined field lengths in my sqlite3 db. I don't want to hard-code 1,000,000,000 or 2147483647 in as the field length - but

Re: [sqlite] cast(count(1) as integer) result is text?

2011-01-24 Thread Vannus
count(1) and cast(count(1) as integer) return null type using above functions On 6 January 2011 03:43, Richard Hipp d...@sqlite.org wrote: On Wed, Jan 5, 2011 at 10:27 PM, Vannus van...@gmail.com wrote: I know sqlite stores data as text, No it doesn't, unless the value really is text

Re: [sqlite] cast(count(1) as integer) result is text?

2011-01-13 Thread Vannus
(missed your message somehow) All 3 return integer in sqlite express (which is good), but zeos doesn't like typeof(). On 6 January 2011 09:12, Simon Slavin slav...@bigfraud.org wrote: On 6 Jan 2011, at 4:00am, Vannus wrote: Using both ZeosLib and SQLite Expert the SubTotal (and count