Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

getting fields in the table

Status
Not open for further replies.

AhmetSinav

IS-IT--Management
Mar 28, 2006
25
TR
Hi;
how can i get the field list from specifed table.
Best Regards.
 
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.
 
how can i get the field properties from specified tables?
 
AhmetSinav,
From the Progress explorer:
Tools -> Data Dictionary -> database -> reports
choose the one you need.
regards,
longhair
 
hi
Thanks but i know it. i want to make it manuallay in runtime.
Regards.
 
FOR EACH _File NO-LOCK,
EACH _Field OF _File NO-LOCK:

/* Do something here */
END.


Cheers, Mike.
 
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.
 
The _Field table contains all the field properties. To look at what fields are available in the _Field table do:
Code:
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top