Re: [sqlite] Releases?

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 wrote: > Where and how do we download releases? The site at > http://system.data.sqlite.org/ leads me eventually to open and

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

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 wrote: > I thought this would be OK but now that

Re: [sqlite] determine SQLITE_MAX_LENGTH or sql_limit/sqlite3_limit

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

[sqlite] determine SQLITE_MAX_LENGTH or sql_limit/sqlite3_limit

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?

is returned. " both 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 tex

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

(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 SQLit