Sean


I tend to use persistent fields almost exclusively for tables, FieldByName for queries and in one case where I have a loop on a query and wanted every bit of speed I could get I worked out the index positions of some of the fields in the table at app start.

Roy Lambert

Roy

I go strait at the required fields with a TList I load with

 MyDataSet.GetFieldList(FMyFieldList, MyFieldNames);  


Then one can iterate the fields with

 for i:=0 to FMyFieldList.Count-1 do
   with TField(FMyFieldList[i]) do
     ...whatever you  want with the field

Bruno