Re: Changing Table in SQL command

Article View: borland.public.vdbase.data.sql

Article #345

Back to borland.public.vdbase.data.sql Previous Next

#345

From: Romain Strieff [TeamB]
Date: Wed, 21 Oct 1998 00:00

24 lines
1188 bytes

In article <6vqdfv$92s4@forums.borland.com>, Tymon Mellor grudgingly 
admits...
> 
> I am using the simple SQL command within a datamodual:-
> 
> Select * from "..\tables\list01.dbf"
> 
> Now  I would like to be able to change the selected table at runtime using
> the global "_app" property.  This is where I cannot get the correct syntax.
> 
> _app.tablename = "list02.dbf"
> 
> 'Select * from "..\tables\'+'"'+_app.tablename+'"'
> 
> can any one advise on the correct syntax?
> 
> 
Additional to the other replies, check database aliases, they were 
invented exactly to avoid this.
-- 
Romain Strieff [TeamB]
check this URL for all the copies of the
previous electronic VdB Newsletters
http://www.openenv.com/feedback/archive/VdBASE/

Technical Details

Message-ID: <MPG.1097fca23628e53098982d@forums.inprise.com>

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

References: <6vqdfv$92s4@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,1fc955414ba2b85
X-Google-Attributes: gidff5a1,public
From: teamb@opto-pps.com (Romain Strieff [TeamB])
Subject: Re: Changing Table in SQL command
Date: 1998/10/21
Message-ID: <MPG.1097fca23628e53098982d@forums.inprise.com>
X-Deja-AN: 403547589
References: <6vqdfv$92s4@forums.borland.com>
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message