Skip to Content
0
Former Member
Feb 28, 2006 at 03:38 PM

Generate table field names dinamically

33 Views

Hello everybody:

I need to get some data from KNC1 table based on a range of fields. Let's say I need the period from 4 to 6 so I need to get these fields:

UM04S

UM04H

UM04U

UM05S

UM05H

UM05U

UM06S

UM06H

UM06U

That is, is there a way for me to loop through the table and dinamically select the fields I'd like to pick, something like concatenating 'UM' + fieldNo + '2' ??

Thanks!

Alejandro