🚀 go-pugleaf

On Wed, 16 Sep 1998 17:13:58 -0400, DALE <dale@catsoftware.com> wrote:

>I am upgrading Dbase IV apps that run multiple instances of the data
>tables on the same drive and the end user creates the directories and
>installs the tables. In the dos versions, I used a macro to let the user
>substitute the desired directory...Use &vpath\tablename. Is there a way
>to do this using the SQL "select * from tablename". Now that I have the
>app almost completed I find that I can't redirect the statement. I also
>tried Set Path and apparently SQL doesn't see that.

A table reference in a local SQL statement may take one of a number of
different forms. One is just the table name:

  FROM Customer

It could include the filename extension and be enclosed in quotation marks:

  FROM "Customer.dbf"

It could be prefixed with the name of a BDE alias (particularly when
multiple tables from different directories are used):

  FROM ":DBDEMOS:Customer.dbf"

And, it could include a drive and directory reference:

  FROM "c:\MyApp\MyData\Customer.dbf"

In the case of these two latter variations, the whole table reference
(including BDE alias name or drive/directory) must be enclosed in quotation
marks.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                "I don't work for any company named Inpoop."
Technical Publications                           -- Steve Koterski, 1957-?
INPRISE Corporation
http://www.inprise.com/delphi