help: multiple values as a TQuery parameter

Article View: borland.public.delphi.database

Article #106

Back to borland.public.delphi.database Previous Next

#106

From: Nostra Damus
Date: Sat, 23 Aug 2003 09:55

13 lines
1109 bytes

In a BDE TQuery component, I need to pass multiple values 
as a parameter.

The SQL property is: 
  SELECT * FROM table WHERE field IN (:myparameter)

The field is numeric type.

After numerous attempts and runtime errors I give up.
Can anyone tell how can I achieve this?

TIA,
ND

Technical Details

Message-ID: <aa3c069d.0308230155.5d106d9b@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,fd88dfcfe47b1199,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2003-08-23 02:55:17 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: nostradumbass77@yahoo.com (Nostra Damus)
Newsgroups: borland.public.delphi.database
Subject: help: multiple values as a TQuery parameter
Date: 23 Aug 2003 02:55:16 -0700
Organization: http://groups.google.com/
Lines: 13
Message-ID: <aa3c069d.0308230155.5d106d9b@posting.google.com>
NNTP-Posting-Host: 61.1.75.119
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1061632517 10344 127.0.0.1 (23 Aug 2003 09:55:17 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 23 Aug 2003 09:55:17 GMT