我在VB程序里用delete语句删除我dbf中的记录，但仅仅是逻辑删除，请问如何物理删除？

[jackeylee]

Public con As ADODB.Connection
Public rs As ADODB.Recordset
Public sqlstr As String
Public Sub OpenCon()
Dim scon As String
scon = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=C:\WINDOWS\Desktop\numbers\dbf;SourceType=DBF;"
Set con = New ADODB.Connection
con.CursorLocation = adUseClient
con.Open scon
End Sub
这是我调用数据库的方法

[cmsoft]

pack

[jackeylee]

pack?难道我每次操作完数据库都用fp打开，pack一下？不太方便吧。

[bimxhd]

关注

[kingsaly]

delete后是否在dbf中之加了个*?,你试试在vfp中用sql-delete是什么效果.

[hdj0569]

调用rs.Updatebatch