Re: [sqlite] Sql Unions

2012-02-10 Thread David Hubbard
I will check and get back to you. I have not really studied it. On Fri, Feb 10, 2012 at 3:52 PM, Richard Hipp wrote: > On Fri, Feb 10, 2012 at 5:28 PM, David Hubbard > wrote: > > > I suspected the odbc layer, but is there any type of logging for SqlLite > to > >

Re: [sqlite] Sql Unions

2012-02-10 Thread David Hubbard
I suspected the odbc layer, but is there any type of logging for SqlLite to verify the sql it gets? On Fri, Feb 10, 2012 at 11:37 AM, Richard Hipp wrote: > On Fri, Feb 10, 2012 at 1:17 PM, David Hubbard > wrote: > > > We are running this from an access front end and the > >

Re: [sqlite] Sql Unions

2012-02-10 Thread David Hubbard
On Fri, Feb 10, 2012 at 9:07 AM, nobre wrote: > > What is the query , and what error do you encounter ? SQLite does support > UNION and UNION ALL > > Regards > nobre > > David Hubbard-4 wrote: > > > > We are looking at using SqlLite from an access appl

[sqlite] Sql Unions

2012-02-10 Thread David Hubbard
We are looking at using SqlLite from an access application, but we have run into troubles executing a query that has a UNION. Does SqlLite support Unions? Any help you can provide would be appreciated. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] sql server management studio like tool for SQLite

2011-11-03 Thread David Hubbard
Is there any tool for SQLite like sql server management studio? We are looking at using SQLite and I have no expireince with it but would like an easy to use tool to use with SQLite that can perform the same functions as SSMS. Or can you connect SQLite to SSMS? Thanks any help received will be app