Re: [sqlite] Re: attached databases

2007-07-05 Thread Tom Deblauwe
Igor Tandetnik wrote: select ID, TimeFrom, TimeTo, Events from db1.tableName where Events=:event union all select ID, TimeFrom, TimeTo, Events from db2.tableName where Events=:event union all select ID, TimeFrom, TimeTo, Events from db3.tableName where Events=:event order by TimeFrom;

Re: [sqlite] Re: attached databases

2006-07-09 Thread carl clemens
Thanks Igor! --- Igor Tandetnik <[EMAIL PROTECTED]> wrote: > carl clemens > > wrote: > > Is there away to get sqlite3 *db pointer to an > > attached database? I'm looking to load user > defined > > functions into them from a shared library. > > User-defined functions are created on a

[sqlite] Re: attached databases

2006-07-08 Thread Igor Tandetnik
carl clemens wrote: Is there away to get sqlite3 *db pointer to an attached database? I'm looking to load user defined functions into them from a shared library. User-defined functions are created on a connection, not on a particular database. Once you install your user-defined functions,