Records in a table = 1 Billion Bytes in .DBF (Table) file = 2 Billion Size in bytes per record (dBASE 4) = 4000 Size in bytes per record (dBASE for Windows) = 32767 Number of fields per table (dBASE 4) = 255 Number of fields per table (dBASE for Windows) = 1024 Number of index tags per .MDX file = 47 Size of character fields = 254 Open master indexes (.MDX) per table = 10 Key expression length in characters = 220
more about DBF files: https://en.wikipedia.org/wiki/.dbf
tip: read about usage of "Sybase Advantage Database" with DBF files
----------------------------------------------
The higher the degree, the greater the respect given to the humblest!RAD 11.3
try convert your DBF file D.O.S. to DBF for Windows and updates your access drivers for it.
Number of fields per table (dBASE for Windows) = 1024
----------------------------------------------
The higher the degree, the greater the respect given to the humblest!RAD 11.3
procedure TForm1.Button1Click(Sender: TObject); var i, j: Integer; begin with ADOQuery1 do begin Close; SQL.Clear; SQL.Add(' select *from infoxx'); Open; end;
//开始从adoquery2中插入数据 到adoquery1(超过255个字段)中 ADOQuery2.First; try while not ADOQuery2.Eof do begin ADOQuery1.Append; for i := 0 to ADOQuery2.FieldCount-1 do begin ADOQuery1.Fields[i].Value := ADOQuery2.Fields[i].Value; end; ADOQuery2.Next; end; ADOQuery1.UpdateBatch(); ShowMessage('已完成'+IntToStr(ADOQuery1.RecordCount)); finally
end;
end; 插入时,超过255个字段就会报错,无法插入。错误提示:adoquery1:list index out of bounds(255)
----------------------------------------------
-