Problem with "Select Into" query

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

Article #5112

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

#5112

From: Guy
Date: Sun, 15 Jul 2001 10:48

21 lines
1429 bytes

Hi,
I wrote a "Select into" query and it doesn't work. (The parameters were
defined properly at design time)

The query:

        Form1->Query1->Parameters->ParamByName("parameter1")->Value = Name;

        Form1->Query1->Close();
        Form1->Query1->SQL->Add("SELECT   Field1  INTO :parameter2  FROM
Table1 WHERE Field2 =  :parameter1");
        Form1->Query1->Open();

And I've got the following error message during executing Open command:
                            invalid host/bind variable name


Can somebody help me please?

Thanks,
    Guy

Technical Details

Message-ID: <3b51671e_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,91b15c90acaec3bd,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-07-15 02:51:20 PST
Reply-To: "Guy" <guy_kariv@hotmail.com>
From: "Guy" <guy_kariv@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Problem with "Select Into" query
Date: Sun, 15 Jul 2001 12:48:18 +0200
Lines: 23
Organization: Student
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 213.8.240.126
Message-ID: <3b51671e_1@dnews>
X-Trace: dnews 995190558 213.8.240.126 (15 Jul 2001 02:49:18 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews