VB6: delete data and pack Visual FoxPro Database

[nicholasting]

with the connection string below, i write the queries

Provider=VFPOLEDB.1;Data Source=C:\VFPDATA;Collating Sequence=MACHINE;Mode=ReadWrite

-------------------------------------------------------
SQL = "DELETE FROM FoxPro_Employee.dbf"
gconn.execute SQL

cmd.CommandText = "Set Exclusive Onack FoxPro_Employee.dbf"
cmd.Execute
-------------------------------------------------------

althought the query is execute successfully, but the records do not deleted.

is that anything i did wrong?

please help!
thanks.

regards,
nicholas

 

[falconsight]

The data has been MARKED for deletion.
The command "SET DELETED OFF" will indicate VFP not to use the deleted records on future queryes.

 

[nicholasting]

thanks "falconsight"

how about if i want delete the all VFP data and pack the database? is that any ways to do in VB6? i would like to have a clean database instead!

thanks for help!