Dynamicly capture Tables

[sebouh181]

Hi again,

im trying to capture all the "Available" table names that i loaded into my program.

for example if i did FIND FIRST "PERSON" where ...

... and whenever i call this code, it must return me the table name "PERSON"

anyone has any idea?
i tried my queries from _File and didnt do the job!!

 

[parul]

two options come to mind:

1) parse the code and capture all the possible combinations
2) Use XREF and check for search...



-Parul.

 

[philippoommen1]

If the code is an executable code then we can find out the read frequency in the db with the help of a VST table called _Tablestat. You have to start the session fresh and execute the mentioned the code and run the following code
For Each _tablestat no-lock :
Find _file where _file._file-number = _tablrstat._tablestat-id no-lock:
Disp _file.file-name.
End.

Hope this will help.
Regards
Philip P Oommen