Re: SQL Query question...

Article View: borland.public.cppbuilder.database.ado

Article #4250

Back to borland.public.cppbuilder.database.ado Previous Next

#4250

From: Joel
Date: Tue, 22 Jan 2002 16:14

28 lines
1552 bytes

Try changing : Shipping Group  to :Shipping_Group . 

If there is a space in the middle the compiler thinks its 2 words...

hope it helps



"Alan S" <al.stanton@verizon.net> wrote:
>Hello,
>
>Trying to execute this query using an ADOQuery component :
>
>Select : Shipping Group from ShippingCosts S where S.Amount =
>(LookupComboBox1->Text);
>
>The parameter : Shipping Group is supposed to pick from the datasource
>component I have specified in the Datasource property of this Query.
>
>I am getting an invalid Parameter error.  Would using Format get this to
>work ?  Not completely sure how to execute this.
>
>Any help offered would be much appreciated.
>
>Al
>
>

Technical Details

Message-ID: <3c4d8fe5$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.he.net!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3c4c77c3_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,329ae10da2d54f30
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-01-22 08:31:53 PST
From: "Joel" <jcma@rnl.ist.utl.pt>
Sender: "Joel" <jcma@rnl.ist.utl.pt>
Reply-To: "Joel" <jcma@rnl.ist.utl.pt>
Subject: Re: SQL Query question...
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 193.136.134.45 193.136.134.45    
References:  <3c4c77c3_2@dnews> 
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3c4d8fe5$1_1@dnews>
Date: 22 Jan 2002 08:14:29 -0800
X-Trace: dnews 1011716069 207.105.83.65 (22 Jan 2002 08:14:29 -0800)
Lines: 29
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.he.net!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message