On Fri, Feb 10, 2012 at 1:17 PM, David Hubbard <[email protected]> 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 valid syntax.
>
> The error is:
> ODBC--call failed.
> near "(": syntax error (1) (#1)
>
There is no "(" character in your input. This makes me suspicious that
there is a bug in your application or in your ODBC driver that is somehow
sending SQL over to SQLite that is different from what you intend.
>
> 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
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
