Regarding _file , _sequence?

[kingganesh04]

I want to know about

1. _file
2. _sequence
3. Is there any other tables are start with _.
4. Codes for list the table's field name, Label Name & format

 

[TomBascom]

Why do you want to know about these? (Understanding your reasons will help to better answer your questions...)

The "_" tables are meta-schema tables. That is to say that they are the tables which describe the structure of your database.

You can get a list of these tables like so:

for each _file no-lock where _file-name begins "_":
  display _file-name.
end.

You might also find Progress Knowledgebase entry P14266, "Where are the PROGRESS Metaschema tables documented?" to be helpful.

 

[kingganesh04]

My question is:

i will give the table name as input,
for that table what are all fields,format,column name and etc to be display.

 

[kingganesh04]

How _file and _field are linked each other?
How can i find out he field names for _< meta - Schema tables > and normal table?
like employee,customer

 

[TomBascom]

Try this: HTMLDict

 

[sphipp]

How _file and _field are linked each other?
How can i find out he field names for _< meta - Schema tables > and normal table?
like employee,customer

Just use _field of _file to link them.

FOR EACH _file WHERE _file._file-name = "customer" NO-LOCK, EACH _field OF _file NO-LOCK:
    DISPLAY _file._file-name _field._field-name _field._label _field._format.
END.