为什么我用VB的ADO访问时,从DBF文件中提取的字段中,金额字段取出的全是四舍五入的整数啊?有的DBF文件就可以,请问如何才能正确取出这个金额值啊?采用以下代码进行连接: dbfDBpath = App.Path
Set dbfConn = New ADODB.Connection
dbfConn.Open "Driver={Microsoft Visual Foxpro Driver};UID=;PWD=;SourceDB=" & dbfDBpath & ";SourceType=DBF;Exclusive=No;"
SQL = "select * from sfk.DBF "
Set dbfRs = New ADODB.Recordset
dbfRs.Open SQL, dbfConn, adOpenStatic, adLockOptimistic
Set dbfConn = New ADODB.Connection
dbfConn.Open "Driver={Microsoft Visual Foxpro Driver};UID=;PWD=;SourceDB=" & dbfDBpath & ";SourceType=DBF;Exclusive=No;"
SQL = "select * from sfk.DBF "
Set dbfRs = New ADODB.Recordset
dbfRs.Open SQL, dbfConn, adOpenStatic, adLockOptimistic
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货