Thank you.

Now it runs both without error (so far)
I have come a little further than before, but I'm not finished yet.

I have made some stored procedures to make the update / insert.

And I have set the unidirectional property to true.
What does this do anyway ?

Michael

--- In ib-support@yahoogroups.com, Phil Shrimpton <phil@s...> wrote:
> On Tuesday 28 January 2003 07:32, you wrote:
>
> Hi,
>
> > It says "Out of memory".
> >
> > My program is made in D5 Enterprise using TIBQuery.
> > I run thruogh some 200.000 records and these cover 2 months of
> > transactions.
> > When I start I create or update some 160000 records in two tables.
> > When I change month I do the same, and at the end again.
> > So I will at the end have created or updated some 500.000 records.
>
> This is really a Delphi/IBX question, but..
>
> If you are using TIBQuery make sure the unidirectional property is
set to
> 'true', or all the records will be buffered in memory 'in the
client'.
> Better still, use a TIBSQL, which does not buffer stuff and is a
lot
> 'thinner'.
>
> Even better, move all this processing to Store Procedures, so it is
done
> server side.
>
> Phil
>
> --
> Linux 2.4.4-4GB
> 6:53am up 14 days, 12:42, 1 user, load average: 0.30, 0.14,
0.05