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()