General discussion

Locked

FoxPro 2.5 Record Deletion

By shahzadsmart ·
i am using FOXPRO 2.5 Database in vb6.
i am deleting records but its's not deleting it just marked as deleted record after that.

i don't want to mark records i want to delete. with just using VB.

Can i do that?
Best Regards for all.
Shahzad.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

FoxPro 2.5 Record Deletion

by Peyison In reply to FoxPro 2.5 Record Deletio ...

You can't just delete a record in an xBase database (which is what FoxPro is). If you want to actually delete the records, you have to pack (not sure if that's the actual FoxPro term) the database. This will remove records marked as deleted.

Collapse -

FoxPro 2.5 Record Deletion

by shahzadsmart In reply to FoxPro 2.5 Record Deletio ...

that what i asked how can i pack database from VB.


can i do that?

Collapse -

FoxPro 2.5 Record Deletion

by MLSmudde In reply to FoxPro 2.5 Record Deletio ...

FoxPro does not physically remove records from a table until it is packed. When deleting a record it will be marked as you stated. This provide an ability to recall deleted records. Within FoxPro you can use a Deleted() function to select/bypass deleted records. I will assume that you are acccessing FoxPro through ODBC and I believe there is a setting to bypass delete records. Check out the Options for the ODBC data source.

Collapse -

FoxPro 2.5 Record Deletion

by shahzadsmart In reply to FoxPro 2.5 Record Deletio ...

that what i asked how can i pack database from VB.


can i do that?

Collapse -

FoxPro 2.5 Record Deletion

by shahzadsmart In reply to FoxPro 2.5 Record Deletio ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums