我想清空一个DBF表,使用ADOSet conmap = New Connection
Set mapRS = New Recordset
Dim aar As String
aar = "Provider=MSDASQL.1;Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + gl_strGISDBPath + "map\" + ";"
'MsgBox aar
conmap.Open aarmapRS.Open "select * from mapdbf", conmap, 3, 2conmap.Execute "DELETE all FROM mapdbf"====这一句出错,我错了吗?
有其他方法可以清空一个DBF表吗?
Set mapRS = New Recordset
Dim aar As String
aar = "Provider=MSDASQL.1;Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + gl_strGISDBPath + "map\" + ";"
'MsgBox aar
conmap.Open aarmapRS.Open "select * from mapdbf", conmap, 3, 2conmap.Execute "DELETE all FROM mapdbf"====这一句出错,我错了吗?
有其他方法可以清空一个DBF表吗?
试试
maprs.open "delete * from mapdbf",conmap,3,3
-------------------------------------------------------------------------------
Set conmap = New ADODB.Connection
Set mapRS = New ADODB.Recordset
Dim aar As String
aar = "Provider=MSDASQL.1;Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + gl_strGISDBPath + "map\" + ";"
'MsgBox aar
conmap.Open aarconmap.Execute "DELETE FROM mapdbf"mapRS.Open "select * from mapdbf where 1 = 0", conmap, 3, 3mapRS.AddNew............