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