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 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 <rafael.ro...@novaprolink.com.br
> > >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
> > > > sqlite-users@sqlite.org
> > > > 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
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
