我有一支程式可執行在WIN98下.....一切正常~
BUT..我將程式的SOURCE CODE放至WIN2000 (P)下時~
有關DBF的UPDATE及DELETE 所有SQL COMMAND 卻不能執行~WHY???
請問我該如何解~

Dim SF As New ADODB.Connection
Dim SF_Rst As New ADODB.Recordset
SF.Open "Provider=MSDASQL.1;Persist Security Info=True;Data Source=dBASE Files;Initial Catalog=D:\ICPRECARD"
SF_Rst.CursorLocation = adUseClient
'SQL = "UPDATE CARD_M SET 加值日期 = " & Format(Now, "yyyy/mm/dd") & " Where 卡號 = 44444444444445"
SQL = "DELETE * FROM CARD_M"
SF_Rst.Open SQL, SF, adOpenDynamic

arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(6) 人氣()