If you are looking to get a list of tables from a remote source to create views for on the fly, use the SPT function SQLTables() to return the list to an array.
As for the SQL to create the view, you have to use &gcTable instead of (gcTable)
>I can run the following query to create the remote view
>Create SQL VIEW rv_SCRFOR;
>connection SCRFOR;
>as SELECT * FROM LH901701.DBF
>but if i use the variable like
>
>gcTable = GETFILE('DBF', 'select a dbf:', 'Ok', 0,;
> 'Select Or Cancel')
> gcTable = UPPER(ALLTRIM(Right(gcTable,12)))
>Create SQL VIEW rv_SCRFOR;
>connection SCRFOR;
>as SELECT * FROM (gcTable)
>
>where gcTable has value "LH901701.DBF", it gives me error
>
>Also Is there any way that I can select the files and get those files in some variable one by one, without allowing the user to select the file first
>
>
>Thanks Bharat
Mark McCasland
Midlothian, TX USA