getting fields in the table

[AhmetSinav]

Hi;
how can i get the field list from specifed table.
Best Regards.

 

[AhmetSinav]

i found it.
FOR EACH _FILE NO-LOCK:
SELECT-1:ADD-LAST(_FILE._FILE-NAME).
END.
this code is insert the fields which table we connect.

 

[AhmetSinav]

how can i get the field properties from specified tables?

 

[longhair]

AhmetSinav,
From the Progress explorer:
Tools -> Data Dictionary -> database -> reports
choose the one you need.
regards,
longhair

 

[AhmetSinav]

hi
Thanks but i know it. i want to make it manuallay in runtime.
Regards.

 

[HelloMike]

FOR EACH _File NO-LOCK,
EACH _Field OF _File NO-LOCK:

/* Do something here */
END.


Cheers, Mike.

 

[AhmetSinav]

hi;
field properties
for example
char X(15)
integer
logical....etc.
_File table include only field names but i want to take field properties like my example. i think i explain my problem about this topic.

Best Regards.

 

[HelloMike]

The _Field table contains all the field properties. To look at what fields are available in the _Field table do:

FOR EACH _File NO-LOCK WHERE _File._File-name = '_Field',
    EACH _Field OF _File NO-LOCK:

    DISPLAY _Field._Field-name.
END.

Then in the query I gave you earlier, you can decide what you need to do in the /* Do Something */ area.

Cheers, Mike.

 

[AhmetSinav]

Thanks;