我原来用数据源链接cn = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=js"
现在直接链接dbf数据库cn = "provider=msdasql;DRIVER=Microsoft Visual FoxPro Driver;UID=;Deleted=yes;Null=no;Collate=Machine;BackgroundFetch=no;Exclusive=No;SourceType=DBF;SourceDB=" & App.Path & "\js.dbf;"
用数据源链接正常的sql，直接链接就出现问题了
sql = "select NAME,cint(THIS_DATA) as sj,THIS_TIME from js where dece_one<>'' and this_time between # " & Format(Text1.Text, "yyyy-mm-dd") & "# and #" & Format(Text2.Text, "yyyy-mm-dd") & "# order by dece_one desc"
出现错误提示错误号：-2147217900 错误信息：[Microsoft][ODBC Visual FoxPro Driver]Syntax error
而且还不认识cint这个函数
请教给为高手
现在直接链接dbf数据库cn = "provider=msdasql;DRIVER=Microsoft Visual FoxPro Driver;UID=;Deleted=yes;Null=no;Collate=Machine;BackgroundFetch=no;Exclusive=No;SourceType=DBF;SourceDB=" & App.Path & "\js.dbf;"
用数据源链接正常的sql，直接链接就出现问题了
sql = "select NAME,cint(THIS_DATA) as sj,THIS_TIME from js where dece_one<>'' and this_time between # " & Format(Text1.Text, "yyyy-mm-dd") & "# and #" & Format(Text2.Text, "yyyy-mm-dd") & "# order by dece_one desc"
出现错误提示错误号：-2147217900 错误信息：[Microsoft][ODBC Visual FoxPro Driver]Syntax error
而且还不认识cint这个函数
请教给为高手
cint(THIS_DATA) as sj换成 THIS_DATA as sj试试