Changing Table in SQL command

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

Article #570

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

#570

From: Tymon Mellor
Date: Sun, 11 Oct 1998 00:00

20 lines
947 bytes

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?

Thanks

Tymon
(Nearly finished the first new V7.1 application)

Visualdb     ver 7.01
Os             Win 98

Technical Details

Message-ID: <6vqdfv$92s4@forums.borland.com>

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: ff5a1,1fc955414ba2b85,start
X-Google-Attributes: gidff5a1,public
From: "Tymon Mellor" <mellort@ap.net.hk>
Subject: Changing Table in SQL command
Date: 1998/10/11
Message-ID: <6vqdfv$92s4@forums.borland.com>
X-Deja-AN: 399933331
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.vdbase.data.sql