General information
Category:
Coding, syntax & commands
>>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only