小弟创建dBase数据库时被卡住了
With adodbfConn
.ConnectionString = "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=" & gblWGOutputPath
.CursorLocation = adUseClient
.Open
SQL = "CREATE TABLE " & strName & _
" ([KH-KDCALL] CHAR(11), [KD-JFJE] D(8)) "
.Execute (SQL)
.Close
End With
提示字段定义语法错误,请问dBase中数值型字段该如何定义?
With adodbfConn
.ConnectionString = "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=" & gblWGOutputPath
.CursorLocation = adUseClient
.Open
SQL = "CREATE TABLE " & strName & _
" ([KH-KDCALL] CHAR(11), [KD-JFJE] D(8)) "
.Execute (SQL)
.Close
End With
提示字段定义语法错误,请问dBase中数值型字段该如何定义?
解决方案 »
- 我一个串口程序,点击按钮获得重量,但是当重量变化时,还是第一次的那个重量,除非重新打开才能获得准确的值。为什么
- 散分,顺便提个问题...
- VB连接数据库的最佳办法,恳请各位楼主为我解答!!!
- 请问如何在一个Access文件中删除一个表?
- 关于datagrid的一个问题,急!
- 用winInet.dll下载和上传文件的过程中,如何能获得当前已下载和上传的文件大小
- 请帮我看看,这样打印图形对吗?关于Printer.PaintPicture
- 国内软件程序员考试含金量如何,请指教?
- QTP弹出对话框勾选结点,回放脚本,父对象不存在(已更新附上脚本).
- 再问,SQL语句中可否有去除所有空格的函数?
- VB中有无移位运算符啊?
- 怎样确定类型?
conn.ConnectionString = "provider=msdasql;DRIVER=Microsoft Visual FoxPro Driver;UID=;Deleted=yes;Null=no;Collate=Machine;BackgroundFetch=no;Exclusive=No;SourceType=DBF;SourceDB=C:\fox\data;"
conn.Open
SQL = "CREATE TABLE " & strName & _
" ([KH-KDCALL] CHAR(11), [KD-JFJE] DOUBLE) "
就行了