>>>You can SCAN table and check for FILE(). You can also use SELECT-SQL:
>>>Select FILE(table1.filename) AS fileexist From Table1
>>
>>Thanks for your prompt reply!! But we mainly want to execute a special routine. Not just check for the filename. How can we do that?
>
>Select-SQL can be extended by using UDF:
>Select myfunction(filename) as result From table1
>
>Function myfunction
>Lparameter cFilename
>DO CASE
>....
>ENDCASE
>Return
>
>However, if you're going to switch work areas you shouldn't use this way, because SELECT can get confused and yield wrong result (usually GPF :). So, for multi-table processings you probably should use SCAN. Certainly, I cannot state it by sure without knowing what exactly you want to process.

Aha. So that possible? Well we want to scan a table which contains filenames of all the tables we will be using in an application. So the way you just mentioned IS possible I guess?

Thanks for your reply!

Greetings,
Michiel Willems
Using the account of Koos Veel