MM> Please share your experience on this one, if any.
  > A guy at work uses StartTransaction and Rollback. These statements invoke 
some
  > sort of record locking to preserve changes for a possible rollback 
operation
  > later. If you push it too far Delphi tells you there are too many record 
locks.
  > Help says there can only be 255 for paradox tables.
MM> Now, the guy at work has found that sometimes he can delete a couple of
  > thousand records and roll 'm all back, no fuzz. At other times he does 
get the
  > message about the record locks.
MM> He would like to know what is happening, why and when.
   Changes are buffered, the old data is retained in the buffer so 
   that it can be restored. The amount of data in the buffer 
   determines the number of records that can be rolled back.
   If he has a lot of records with only a small amount of data in 
   them, AND if the buffer was cleared because the transaction 
   session was only recently started or if a comit had flushed the 
   buffer, then he would have more room for more records.
   Don't ask me where the buffer is at, I don't know.
                                       LRA
 -- SPEED 2.00 #2720: Windows: Micro$oft's ode to P. T. Barnum
--- Platinum Xpress/Win/Wildcat5! v2.0
---------------