Hi all,
i have so many .fex &.Htm files in my development for the Dashboard.some times i find difficult to find the location of a .fex or .htm file that is being use in the dashboard.is there any way that i can know where exactly the location of the file by a simple process in the command console of WebFocus instead of searching for so much time....

This message has been edited. Last edited by: Kerry,

Are these files on the WF Server or in MRE ?

they are part of the Web server not MRE,I have some hundreds of .fex and .htm files in the server,these are being used in the dashboard.so i want to know where they are located in the web server by any simple process.

How about using SYSFILES

SQL FMI SET SYSFILES FOCEXEC
TABLE FILE SYSFILES
PRINT *
END

SQL FMI SET SYSFILES HTML
TABLE FILE SYSFILES
PRINT *
END

Waz has the answer!

Here's some more reading material:

Is it possible?

Using APP QUERY How to display All .mas files in All application folders

[SOLVED] SYSCOLUM for FILES

Waz,

Thanks for the FMI! Now that you have shown this it reminds me that actually, this syntax originally belonged to asking which members are allocated by a certain DDNAME. Apparently it works also in the non-MF sphere.

FMI can also be used to find DEFINES in master files and elsewhere:

  
SQL FMI SET FILECASE UPPER
-RUN
SQL FMI SET TEMPDEFINES ON
-RUN
SQL FMI SET SYSFILES MASTER
-RUN
TABLE FILE SYSCOLUM
 PRINT DEFTEXT/A80
 BY FILENAME
 IF DEFTYPE EQ 'P' OR 'T'
END

Thanks Guys....