Hi all!

I'm trying to write a little program to scan through a list of directories and tables and perform some tasks on each of the tables in the various directories.

I'm using a SCAN..ENDSCAN of my directory and table lists to get the variables needed to use the appropriate files. And I've figured out how to USE the appropriate table using the variables with the following command:

USE ("c:\ird98\surveys\"+mydirectory+"\"+mytablename) IN 0

and I was trying to do the following to select the work area with the above table but it doesn't work:

SELECT ("c:\ird98\surveys\"+mydirectory+"\"+mytablename)

Does anyone know what the code should be??

MTIA!
Mandy