VishalMistry
16th April 2015, 08:43
Hi all,

Is there any way to programmatically listing all the fields of table ?

I mean how to count the fields and loop through all of them ?

Vishal

sachinbaan
16th April 2015, 08:47
hi,

try rdi.table().

bhushanchanda
16th April 2015, 12:07
Hi,

What do you mean when you say "loop through them"? rdi.table() will give you the number of fields including Refcntd,Refcntu,_compnr,_dlock and will add 1 count for each index.

If you just want to count the table fields, you can also use ttadv422 table in company 000 with count(*) function for a specific VRC.

mark_h
16th April 2015, 15:17
And search code and utilities might find some code for you to start with - http://www.baanboard.com/baanboard/showthread.php?t=526. There might even be other threads about it.

JaapJD
16th April 2015, 17:36
@Bhushan: go always for rdi.* functions. Those reflect the real runtime situation. ttadv422 may have changes that are not converted to runtime yet.

bhushanchanda
16th April 2015, 17:40
@Bhushan: go always for rdi.* functions. Those reflect the real runtime situation. ttadv422 may have changes that are not converted to runtime yet.

Yup. That's true. Just made him aware about how it works with rdi.table()