Hi,

How can I find number of columns in particular table, also how can we loop through all the fields of that specific table to find name of each field.

Vishal

Hi,

You can do that by writing a select on ttadv422 (Table Fields).

use the "count" in the select statement to find out the number of fields (make sure you are in the right VRC).

- George

You can use rdi.table() and rdi.table.column() function to get total no of fields and field name of specific table.

Thanks a lot manish.

Vishal

rdi functions also consider combined field , indices and reference counters as fields . So in ur field counters u may need to adjust ur code to know what u want . But certainly rdi functions is nore reliable way to go where u'll get all related answers (and if u r to determine this within baan)