In FoxPro the command 'DELE' is used to

2013

In FoxPro the command 'DELE' is used to

  1. A.

    Delete all records

  2. B.

    Delete table

  3. C.

    Delete marked records

  4. D.

    Mark the records for deletion

Attempted by 1 students.

Show answer & explanation

Correct answer: D

Concept

In FoxPro and every xBase language, deleting a record is a two-step process. A record is never erased the instant you ask for it: it is first flagged, and only a later, separate command physically rewrites the table without the flagged rows. xBase commands may also be shortened to their first four letters, so DELE is simply the abbreviation of DELETE.

Applying it here

  • DELETE (typed as DELE) sets a deletion flag on the current record (or on a range given by a scope/FOR clause). The data stays in the file and on disk.

  • While only flagged, the record can still be read, and the flag can be removed with RECALL — proof that nothing has actually been erased.

  • PACK is the command that physically rewrites the table, dropping every flagged record permanently. ZAP removes all rows at once.

Conclusion

Therefore DELE only marks the current record(s) for deletion; the physical removal happens later, with PACK.

Explore the full course: Up Police Computer Operator