Click above to get retro games delivered to your door ever month!

   Replaces and Appends
------------------------------------------------------------------------------

   All REPLACE and APPEND commands associated with a "transaction" should
   be issued between the BEGIN TRANSACTION and COMMIT/ROLLBACK TRANSACTION
   commands.

   Note:  In order for new index keys to be built for appended records
   during a transaction, the appended records are actually inserted into
   the table before the transaction has been committed. If the
   transaction is rolled back, the appended records are not removed from
   the table since another user may have appended additional
   records. Therefore, if a transaction is rolled back, the Advantage TPS
   clears out all the fields in the appended records, marks the appended
   records for deletion, and inserts keys into the associated indexes to
   reference the deleted, appended records. A record re-use algorithm can
   be implemented, if desired, to account for and re-use these deleted,
   appended records. A periodic PACK of the table would physically
   remove these deleted appended records from the table.