how to call a field by fieldref

nightrod · 2010-02-13

Hi,

How can you call a field by reference.

in a table there are 100 fields called
import01
import02
import03
..
import99

in a report i want to do as followes

i := 1

repeat
get the value of field(import + i);
Run a function;

write to field (import + i);
i = i+1;
until i = 99;

i try using the fieldref and recordref but cant figure out how to do it.
can someone help get started with this?
thanks!

matttrax · 2010-02-13

Have you searched the forum? There are some excellent examples in other posts.

nightrod · 2010-02-14

yes i did but couldnt find what i need.

rmpatel22 · 2010-02-14

I think its not possible.

I tried to do this thing for one report, I tried all options, but no luck.

reijermolenaar · 2010-02-14

Hi nightrod,

You can use the field table to get the fieldnumber and use this to retrieve the fieldref.

YourTable.FINDFIRST;
RecRef.GETTABLE(YourTable);

REPEAT

  i += 1;

  Fld.SETRANGE(TableNo, DATABASE::"Your Table");
  Fld.SETRANGE(Fld.FieldName, 'import' + FORMAT(i));
  Fld.FINDFIRST;

  FldRef := RecRef.FIELD(Fld."No.");
  MESSAGE(Fld.FieldName + ': ' + FORMAT(FldRef.VALUE));

UNTIL i = 99;

nightrod · 2010-02-14

Hi Reijer,

This works great. \:D/
Thanks a lot =D>

Nightrod

rmpatel22 · 2010-02-15

Thanks Reijer

This code can resolve my report problem also.

reijermolenaar · 2010-02-15

you're welcome!

how to call a field by fieldref

Comments

Categories