Strange Problem Posting Records

[G. Bradley MacDonald]

Hello

I am having a very strange problem while converting records from one
table to another.

I am using D7 - with DBExpress

It goes through about 65680 records - and then crashes with the
following errors:
1. Invalid BLOB handle in record buffer.
2. Insufficient memory for this operation.
3. Delta is empty.
Then it just keeps repeating error #3

I am processing table 1 in a loop - and every few records I am
applyingupdates and then committing the records to the new table.

I initially thought it was a data problem - but then I ran it from
record 64000 on - and it ran fine. I also noticed that it fails on a
Win2003 Server - but works fine on a XP machine.

Any one with any thoughts as to what I might be running into???

[Bill Todd [TeamB]]

You should not use a ClientDataSet for bulk processing of large numbers
of records. Read the records from the soure SQLDataSet and use a
parameterized INSERT statement in a second SQLDataSet to insert the
records into the target table.

[G. Bradley MacDonald]

Post by Bill Todd [TeamB]
You should not use a ClientDataSet for bulk processing of large numbers
of records. Read the records from the soure SQLDataSet and use a
parameterized INSERT statement in a second SQLDataSet to insert the
records into the target table.

Hello Bill,

thank you - I will try that.

The interesting part is that I process over 200,000 records from another
table - including another 200K of images being posted using a CDS - and
it works fine.