:: Why do you need to select the record first?

Basically there are a series of records that need calculations performed on
some fields. So its select, calc, update. The select could be done as one
big one, but it would create huge lists of IN to get the key list.

:: >Sometimes we get this:
:: >Exception Details: FirebirdSql.Data.Firebird.FbException: I/O error
:: >during "CreateFile (open)" operation for file
::
:: This error comes from your interface (dotnetprovider?)

Yes.

:: >"D:\IISDomains\purchase.atozed.com\Data\APPRinok.gdb" Error while
:: >trying to open file
::
:: This is gdscode 335544734. It can occur when the server is
:: asked to do a grouping or a sort and can't find its
:: temporary sort space; or there is not enough temporary sort

There wasn't any grouping or sorting going on that I can see.

:: space available for the sort operation. It's probably
:: unrelated to your other problem; but it could be that the
:: firebird.log has blown out the available space on the
:: partition where it lives.

Each system had min 12.5G free.

:: >[FbException: Error reading data from the connection.
:: >]
:: > FirebirdSql.Data.Firebird.FbTransaction.Rollback() +121
:: > ADOPlus.DBConnection.RollbackTrans() +13
::
:: Something is going on in your interface in response to an
:: unhandled exception from the server which, eventually,

Well actually its responding right. When I look at Guardian, the server just
crashed. So as far as the client was concerned - it did lose the socket.
That's all the client could see is that the connection just died.

:: crashed something. Can't tell from your info whether it was
:: the application that crashed, or the server. The
:: firebird.log would give you more information about that.

KUDZU (Client) Wed Oct 06 12:02:48 2004
C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (3221225794)

Hope this helps. Ive worked around this issue now by limiting the
transaction to 50, but they are in "groups" and the user could create say 10
groups of 50, and Im not sure at what point this crash occurs...