From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham
	autolearn_force=no version=3.4.4
X-Google-Thread: 103376,9986f50b2446f516
X-Google-NewGroupId: yes
X-Google-Attributes: gida07f3367d7,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: 
 g2news2.google.com!news2.google.com!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!nntp.club.cc.cmu.edu!feeder.erje.net!news2.arglkargh.de!news.karotte.org!uucp.gnuu.de!newsfeed.arcor.de!newsspool3.arcor-online.net!news.arcor.de.POSTED!not-for-mail
Date: Mon, 05 Jul 2010 22:13:05 +0200
From: Georg Bauhaus <rm-host.bauhaus@maps.futureapps.de>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
 rv:1.9.2.4) Gecko/20100608 Thunderbird/3.1
MIME-Version: 1.0
Newsgroups: comp.lang.ada
Subject: Re: gnade odbc and join tables
References: 
 <1265b06d-298d-4d1d-ae74-61262605262f@x27g2000yqb.googlegroups.com>
In-Reply-To: 
 <1265b06d-298d-4d1d-ae74-61262605262f@x27g2000yqb.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <4c323cd1$0$6889$9b4e6d93@newsspool2.arcor-online.net>
Organization: Arcor
NNTP-Posting-Date: 05 Jul 2010 22:13:05 CEST
NNTP-Posting-Host: 85993c0b.newsspool2.arcor-online.net
X-Trace: 
 DXC=dSL:ARi:0gF@Y=h<_c3PkHA9EHlD;3YcB4Fo<]lROoRA8kF<OcfhCOKTZmaVk1ol`JPCY\c7>ejVHb2iY]SoGZ5C_0Y=\DRD`aF
X-Complaints-To: usenet-abuse@arcor.de
Xref: g2news2.google.com comp.lang.ada:13169
Date: 2010-07-05T22:13:05+02:00
List-Id: <comp.lang.ada>

On 7/5/10 7:59 PM, tonyg wrote:

>           SQLPrepare (StatementHandle,
>                      "SELECT "&  QuoteIdentifier ("HEATER.MACID")&  ",
> "&
>                         QuoteIdentifier ("ROOM.PLANID")&  ", "&
>                       " FROM "&  QuoteIdentifier ("HEATER")&  " JOIN"
>

I believe you have an extra comma after ROOM.PLANID, before FROM.