[ODBC Visual Foxpro driver] syntax error错误求救
下面代码执行时报错：“-2147217900(80040e14) [ODBC Visual Foxpro driver] syntax error”
哪位好心人能帮忙看下嘛？
Adodc1.ConnectionString = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=" & App.Path & "\dbf\database.dbc;SourceType=DBF;"
Adodc1.RecordSource = "select * from dbf\czyinfo where 用户名='" + str1(1) + "'"
Adodc1.Refresh
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("编号") = "001"
Adodc1.Recordset.Fields("用户名") = "超级管理员"
Adodc1.Recordset.Fields("密码") = Text2.text
Adodc1.Recordset.Fields("头像") = "00.gif"
Adodc1.Recordset.Fields("员工编号") = "CJGLY01"
Adodc1.Recordset.Fields("销售管理") = 1
Adodc1.Recordset.Fields("库存管理") = 1
Adodc1.Recordset.Fields("基础信息") = 1
Adodc1.Recordset.Fields("员工信息") = 1
Adodc1.Recordset.Fields("配送管理") = 1
Adodc1.Recordset.Fields("往来管理") = 1
Adodc1.Recordset.Fields("报表管理") = 1
Adodc1.Recordset.Fields("决策管理") = 1
Adodc1.Recordset.Fields("维护管理") = 1
Adodc1.Recordset.Update
[解决办法]
Adodc1.ConnectionString = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=" & App.Path & "\dbf;SourceType=DBF;"
Adodc1.RecordSource = "select * from czyinfo where 用户名='" + str1(1) + "'"
Adodc1.Refresh
