As you know, when deleting, data in DBF becomes "hidden" - marked for deletion, like so)

Provider = VFPOLEDB

Questions:

  • How to delete data immediately?
  • Is it possible to delete new data (overwrite and remove the deletion mark) instead of the deleted (hidden) record when deleting through a simple "Delete"?
  • Is the c # label really relevant to the question? - 4per
  • I'm not sure, just all the work with dbf will go through an application developed in C # - Alias ​​Tray

1 answer 1

  1. Run the PACK command. Important: the connection must be with the EXCLUSVE=YES parameter (similar to the FoxPro USE <table> EXCLUSIVE ). Other users will not be able to use an open exclusive table.
  2. You can play with the DELETED parameter (again, the equivalent of SET DELETED ON/OFF in FoxPro). Accordingly, when it is necessary to overwrite the data set DELETED=NO , update the data, do RECALL . But this is somehow wrong in my opinion. Removed - then deleted.
  • I will try, thanks! - Alias ​​Tray