1.引用ODBC打开DBF大量消耗内存,出现死机
ADOTable1.Close;
ADOTable1.ConnectionString:='Provider=MSDASQL.1;Persist Security Info=False;'+
'Extended Properties="Driver={Microsoft FoxPro VFP Driver (*.dbf)};UID=;'+
'SourceDB=c:\F.dbf';SourceType=DBF;Exclusive=yes;BackgroundFetch=no;'
'Collate=Machine;Null=Yes;Deleted=Yes;"';
ADOTable1.TableName:=GetShortFileName(tempDBF);
ADOTable1.Open;
2.用dBase打开Foxpro(*.DBF),不能读取小数点后六位的数据(0.000123)返回为空值
ADOTable1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;'+
'Data Source='+ExtractFileDir(tempDBF)+';Extended Properties=dbase5.0;Persist Security Info=False';
ADOTable1.Close;
ADOTable1.ConnectionString:='Provider=MSDASQL.1;Persist Security Info=False;'+
'Extended Properties="Driver={Microsoft FoxPro VFP Driver (*.dbf)};UID=;'+
'SourceDB=c:\F.dbf';SourceType=DBF;Exclusive=yes;BackgroundFetch=no;'
'Collate=Machine;Null=Yes;Deleted=Yes;"';
ADOTable1.TableName:=GetShortFileName(tempDBF);
ADOTable1.Open;
2.用dBase打开Foxpro(*.DBF),不能读取小数点后六位的数据(0.000123)返回为空值
ADOTable1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;'+
'Data Source='+ExtractFileDir(tempDBF)+';Extended Properties=dbase5.0;Persist Security Info=False';
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货