Need generic way to loop through the fields in a record

GaryD

Hello all,

We're using NAV 5.0 SP 1 with a SQL Server database. We have the need for a generic routine that when passed a table name and maybe some other filter criteria, to be able to go to that table and for each record, grab the field caption along with the value of the field, and put this information into a comment field in another table. I can do most of this but I don't know how to loop through the fields of a record without hardcoding for a particular table. Any help here would be greatly appreciated!

Thanks!

kriki

Take a look at recordreference and fieldreference for that.
Check the help or search the forum for examples.

GaryD

kriki, thanks for the nudge in the right direction! It's working now.