|
This command marks records for deletion. To physically delete a record, you'll need to use the DBPack command. This approach has two primary advantages. First, it can be undone as long as the second step hasn't yet been taken. Second, it is more efficient than the one-step approach since the sometimes time-consuming process of compacting the database only takes place once on demand rather than after each batch of records is deleted.
Type the following line, supplying your own record numbers, to carry out the first step in this two-step deletion:
put DBDeleteRecs(9,23) into dbResult
These files are now marked for deletion. They will be permanently removed and compacted when issuing a DBPack command.
DBPack and DBZapRecs now optimize memo files associated with the packed database. In previous FileFlex versions, when a record was deleted in a memo file, the data was retained inside the file. In FileFlex 3.0 and above, the deleted space is reclaimed from the memo file by DBPack and DBZapRecs.
|