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
> > 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
