Parameter problems using TADOQuery

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

Article #2351

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

#2351

From: Vidar Litlehamar
Date: Thu, 28 Aug 2003 22:18

18 lines
1660 bytes

I've got a file with my sql statements. This is loaded using
MyADOQuery->SQL->LoadFromFile(...

Everything works fine until I try to use the parameters collection.

I've changed my ... where orderno = '3211'      to    where orderno =
:MyInputParm

In my code I do a load from file ... when I check there is a paramcount of 1
(or two or three ... I've tried it all). I then add my parmeter using
"MyADOQuery->Parameters->Items[0]->Value = "132"; ... and run the query
using ExecSQL();

Here is where I get an ODBC error saying there is something wrong with my
SQL statement... (looks like SQL strings collection has got some strange
data instead of 132......

Anyone ?

Technical Details

Message-ID: <3f4e806d@news.broadpark.no>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!nntp.gblx.net!news.broadpark.no

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,a7114e74f83fa3f7,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-08-28 15:19:31 PST
From: "Vidar Litlehamar" <someone@somewhere.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Parameter problems using TADOQuery
Date: Fri, 29 Aug 2003 00:18:57 +0200
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 40.80-202-35.nextgentel.com
X-Original-NNTP-Posting-Host: 40.80-202-35.nextgentel.com
Message-ID: <3f4e806d@news.broadpark.no>
X-Trace: news.broadpark.no 1062109293 40.80-202-35.nextgentel.com (29 Aug 2003 00:21:33 +0200)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!nntp.gblx.net!news.broadpark.no