Article View: borland.public.cppbuilder.database.ado
Article #4054what's wrong with this sql statement
From: Dave J
Date: Fri, 29 Mar 2002 17:37
Date: Fri, 29 Mar 2002 17:37
13 lines
1439 bytes
1439 bytes
the following sql statement works in the SQL Explorer ... but when I try to use it in an ADOQuery it gives error message "incomplete query clause". select d1.plant_name, d2.model_number, d2.name, d2.category, d3.ID, d3.quanity from "inventory" d3, "part" d2, "plant_info" d1 where (d2.part_id = d3.part_ID and d3.plant_ID = d1.plant_ID) order by plant_name Any help will be appreciated, Dave
Technical Details
Message-ID:
<a828os$vn9$1@slb6.atl.mindspring.net>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!yellow.newsread.com!bad-news.newsread.com!news-xfer.newsread.com!netaxs.com!newsread.com!feed2.news.rcn.net!rcn!newsfeed1.earthlink.net!newsfeed2.earthlink.net!newsfeed.earthlink.net!newsfeed0.news.atl.earthlink.net!news.atl.earthlink.net!news.mindspring.net!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,a91012b0c2b02ee7,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-03-29 09:38:12 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!yellow.newsread.com!bad-news.newsread.com!news-xfer.newsread.com!netaxs.com!newsread.com!feed2.news.rcn.net!rcn!newsfeed1.earthlink.net!newsfeed2.earthlink.net!newsfeed.earthlink.net!newsfeed0.news.atl.earthlink.net!news.atl.earthlink.net!news.mindspring.net!not-for-mail From: "Dave J" <email@home.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: what's wrong with this sql statement Date: Fri, 29 Mar 2002 12:37:41 -0500 Organization: MindSpring Enterprises Lines: 18 Message-ID: <a828os$vn9$1@slb6.atl.mindspring.net> NNTP-Posting-Host: d1.56.4d.47 X-Server-Date: 29 Mar 2002 17:37:32 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000