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
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 application, but we have
run
into troubles executing a query that has a UNION.
Does SqlLite support Unions? Any
We are running this from an access front end and the
simplest example of a query that generates this error is:
SELECT MDR.MDR_No
FROM MDR
UNION
SELECT MDR_Archive.MDR_No
FROM MDR_Archive;
The error is:
ODBC--call failed.
near (: syntax error (1) (#1)
and MDR_No is a string field.
On Fri,
On Fri, Feb 10, 2012 at 1:17 PM, David Hubbard dgxhubb...@gmail.com wrote:
We are running this from an access front end and the
simplest example of a query that generates this error is:
SELECT MDR.MDR_No
FROM MDR
UNION
SELECT MDR_Archive.MDR_No
FROM MDR_Archive;
The above is perfectly
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 d...@sqlite.org wrote:
On Fri, Feb 10, 2012 at 1:17 PM, David Hubbard dgxhubb...@gmail.com
wrote:
We are running this from an access front end
On Fri, Feb 10, 2012 at 5:28 PM, David Hubbard dgxhubb...@gmail.com wrote:
I suspected the odbc layer, but is there any type of logging for SqlLite to
verify the sql it gets?
No. We've always assumed that the application developer knows what he is
sending into SQLite, or else can write his
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 d...@sqlite.org wrote:
On Fri, Feb 10, 2012 at 5:28 PM, David Hubbard dgxhubb...@gmail.com
wrote:
I suspected the odbc layer, but is there any type of logging for SqlLite
to