From: Stephen Leake <stephen_leake@stephe-leake.org>
Subject: Re: gnade odbc and join tables
Date: Tue, 06 Jul 2010 02:09:55 -0400
Date: 2010-07-06T02:09:55-04:00 [thread overview]
Message-ID: <82lj9pm98s.fsf@stephe-leake.org> (raw)
In-Reply-To: 1265b06d-298d-4d1d-ae74-61262605262f@x27g2000yqb.googlegroups.com
tonyg <tonythegair@googlemail.com> writes:
> I'm adapting the odbc demo in gnade to learn more about it. I want to
> be able to join tables and do a select according to the query string
> included in the code fragment.
Others have commented on your SQL syntax.
One way I find useful to debug things like this is to run the query in
an interactive front end for the database involved; the sql error
messages tend to be better, and it's easier to modify the syntax and try
again.
MySQL on Windows has a nice GUI for this, including some help on SQL
syntax (although it tends to leave out the basic stuff and focus on the
advanced stuff).
--
-- Stephe
prev parent reply other threads:[~2010-07-06 6:09 UTC|newest]
Thread overview: 5+ messages / expand[flat|nested] mbox.gz Atom feed top
2010-07-05 17:59 gnade odbc and join tables tonyg
2010-07-05 20:13 ` Georg Bauhaus
2010-07-05 20:35 ` Ludovic Brenta
2010-07-06 6:30 ` tonyg
2010-07-06 6:09 ` Stephen Leake [this message]
replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox