Programatically iterate record fields

Jaydk

Is it possible to programatically iterate the fields of a table ? lets take table 18, is to possible to write some sort of loop which write the field captions or names to a MESSAGE() ?

MBerger

yes, look up RecordRef and FieldRef in the helpfile.

Belias

"Field" table can be useful (and simpler, if your purpose is only to message out fieldcaptions).
You can see the structure of this table creating a tabular form based on it with the wizard.
(i use this table to loop each field of the table, without writing them all)

tompynation

Field.SETRANGE(TableNo,18);
Field.SETRANGE(Class,Field.Class::Normal);
Field.SETFILTER(Type,'<>%1',Field.Type::BLOB);
Field.SETRANGE(Enabled,TRUE);
Field.FIND('-');
REPEAT
MESSAGE(FORMAT(Field.FieldName));
UNTIL Field.NEXT = 0;