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 own wrapper to trace what is
going into SQLite. We don't have any provisions to debug intervening ODBC
layers. Does your ODBC driver has a feature to trace the output it sends
to SQLite?
> 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
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
