1,217
社区成员
发帖
与我相关
我的任务
分享dBase的数据类型
小弟创建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中数值型字段该如何定义？
...全文
请发表友善的回复…
发表回复
gdutqhl 2004-06-23
- 打赏
- 举报
问题已解决，改成
SQL = "CREATE TABLE " & strName & _
" ([KH-KDCALL] CHAR(11), [KD-JFJE] DOUBLE) "
就行了
SQL = "CREATE TABLE " & strName & _
" ([KH-KDCALL] CHAR(11), [KD-JFJE] DOUBLE) "
就行了
饮水需思源 2004-06-23
- 打赏
- 举报
Dim conn As New ADODB.Connection
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
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
