PRODUCT  :  Paradox Engine                        NUMBER  :  1003
  VERSION  :  All
       OS  :  All
     DATE  :  October 19, 1993                         PAGE  :  1/1

    TITLE  :  Error #50--Another user deleted record




  This message describes normal behavior for the Engine.  Whenever
  you have a table open more than once, it is often equivalent to
  having more than one 'user' for that table.  For each
  tablehandle, you have a 'cursor' which indicates the current
  position in the database.  If you open a table on one index and
  somehow cause a record to be deleted, and the cursor for the
  other opening of the table pointed to this record that was
  deleted, it now will point to a record that does not exist.
  Whenever you try to do anything with this table, the Engine will
  inform you that another 'user' deleted this record--Error #50.
  This really is an information message, not an error.

  Should this situation occur, you need to reposition the cursor.
  Create an algorithm to do so that will take into account various
  situations, for example, tables without any records left, delete
  at beginning of table, end of table, etc.  One additional
  strategy is to insert a null record in the table at position 1
  and then position to that record.

  In summary, take care when opening tables multiple times and
  handle error/status messages appropriately.  Also, remember that
  doing a PXRecUpdate() on a keyed table and changing the keyed
  fields of a table results in the deletion and readdition of that
  particular record.

  DISCLAIMER: You have the right to use this technical information
  subject to the terms of the No-Nonsense License Statement that
  you received with the Borland product to which this information
  pertains.