I use something like:
var
fldno_FirstField : integer;
fldno_SecondField : integer;

Then just before the looping i do:

fldno_FieldField := SomeTable.FieldByName('FirstField').FieldNo;

and then do the loop:
...
n := SomeTable.Fields[fldno_FieldField].AsInteger;
...

Steve Fields

Norman Dunbar wrote:

>Riho,
>
>I use :
>
>const int fld_forename = 0;
>const int fld_surname = 1;
>...
>
>then I access the field s by ...fields[fld_forname]...
>
>All I have to do is change the const ints :o)
>
>HTH
>
>regards,
>Norman
>
>-------------------------------------
>Norman Dunbar
>Database/Unix administrator
>Lynx Financial Systems Ltd.
>mailto:Norman.Dunbar@...
>Tel: 0113 289 6265
>Fax: 0113 289 3146
>URL: http://www.Lynx-FS.com
>-------------------------------------
>