Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Unanswered: Deleting records from a DBF

    I have an application where I need to delete records from a DBF file. I am accessing the DBF through OLE. When I run a DELETE SQL command, some programs (such as Excel) see that the records are deleted, but there is a specific program that this is for that still sees the records. Is there a way that these records can be completely removed from the file through the OLE data provider?

    Thanks,

    Brian

  2. #2
    Join Date
    Jul 2001
    Location
    NC
    Posts
    102
    BJHill2112

    Its been a while since I've worked with a dbf table, but I recall that so-called "deleted" records were simply TAGGED as deleted in the table, and invisible to all but low-level operations. If I remember right, the way to remove "deleted" records is to make a copy the dbf table.

  3. #3
    Join Date
    Nov 2002
    Location
    Ohio
    Posts
    90
    They should also go away if you backup/restore or complress the database.
    Bruce Baasch

  4. #4
    Join Date
    Nov 2002
    Posts
    2
    Originally posted by Bruce A. Baasch
    They should also go away if you backup/restore or complress the database.
    The problem is that they are stand alone DBF files, not part of any real database.

    Brian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •