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 <[email protected]> wrote:
> On Fri, Feb 10, 2012 at 5:28 PM, David Hubbard <[email protected]> > 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 <[email protected]> wrote: > > > > > 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 > > > > > _______________________________________________ > > 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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
