How do I delete a foxpro record from vb4.0?
Quote:
> HI...
> How do I delete a foxpro record from vb4.0 ? I have managed to mark it as
> deleted ,but it still gets read. Is there some sort of Pack or compress command
> I can use to actually wipe the record out of the database ? or am I stuck with
> the record forever ?.
> Any help would be appreciated ...Thanx in advance
I use this technique with dBase and it works quite well.
Open the database with OpenDatabase method with connect string "FoxPro 2.5;".
Open a recordset with vbDynaset option. Search the record You want to delete. Delete it and
do a Requery on the same Dynaset.