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, Feb 10, 2012 at 9:07 AM, nobre <[email protected]>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 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
> > [email protected]
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/Sql-Unions-tp33301365p33301398.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
