Dalton,

> I guess this is a support question vs a development question, as it
> concerns an earlier version of Firebird.

Given the details, I suspect that this might be an appropriate subject
for the devel list.

> Does anyone one know if there is a maximum number of inserts that can

be

> performed in a single transaction?

Well, updating 32 million rows is not something that is "commonly done".
So, thinking of this as the limit would not be surprising.

> I am getting the error about the 32 million row mark and it strikes me
> that is the area of a signed 32bit number.

A 32 bit integer is significantly larger than 32 million (2 full orders
of magnitude).

[you were typing while you where on the phone, right? ;-) ]

> Is this a known limit to the number of DML within a single

transaction?

> If I break it up to span two transactions, my problem goes away.
> If this is a known limit, has it been removed in more recent versions

of

> Firebird?

I can't think of any change which would have increased this "limit"


Sean