Thank you every body, this is a good suggestion I think, and sory for
uppercase typing, I will not do this again
Kursat

****************************************************************************
**********************


Ops. That uppercase was driving me crazy but... I will try to help.

Suggestion:

a) Create a Table that will old the copy of all info from the external file,
with all fields that you have needed from that external File;
b) In your delphi application, 'pump' all data to that table. You must start
by deleting all records (delete * from TableBlaBla), and dupping the values
from the external table to that table (I know you re using IBO, so take a
look at IB_Import component - it will do what you want to do, even with
non-fixed len fields in your external table).
c) Once you have your data in that table, you can use SQL to do whatever you
want.

I think your main problem will be solved with this, with little code. If I
have understood well, you don't want to simply import the data, but get some
statistics values first. This will help you, for shure.

In your case, forget the external File. You must take the suggestion in this
list as 'suggestions' and not 'rules'.

Artur Anjos