dynamic tablename in TQuery

Article View: borland.public.delphi.database

Article #1981

Back to borland.public.delphi.database Previous Next

#1981

From: Mario Verschuur
Date: Mon, 08 Mar 1999 00:00

17 lines
1353 bytes

I'm trying to do a query on a specific table. But since I've got multiple
tables ( for each year a paradox-table) I want to change the table I'm using
using the params property. But I'm getting an error "token : ?", which would
suggest that the parameters isn't substituted correctly.

I was wondering if this is possible at all, and if possible how do I solve
this problem. Since I wanted to continue my development I worked around the
problem by editting the SQL property and replacing the tablename. But this
isn't a very elegant solution.

So anyone ???  Any help would be appreciated.

--
-------------------------------------------------
Mario Verschuur
Barendrecht, The Netherlands
Email : Mario@Mediaport.Org

Technical Details

Message-ID: <7c07oo$g51$2@news2.xs4all.nl>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,3f34fd4a08ac0774,start
X-Google-Attributes: gid115d96,public
From: "Mario Verschuur" <Mario@mediaport.org>
Subject: dynamic tablename in TQuery
Date: 1999/03/08
Message-ID: <7c07oo$g51$2@news2.xs4all.nl>
X-Deja-AN: 452516070
X-NNTP-Posting-Host: dc2-isdn764.dial.xs4all.nl [194.109.150.252]
Sender: emo@dc2-isdn764.dial.xs4all.nl
X-XS4ALL-Date: Mon, 08 Mar 1999 11:11:36 CET
X-XS4ALL-User: emo
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: XS4ALL, networking for the masses
Newsgroups: borland.public.delphi.database