//////begin Fields Name FieldNames := ''; cdsHHBSCOMClient.First; for i := 0 to cdsHHBSCOMClient.FieldCount - 1 do begin FieldNames := FieldNames + cdsHHBSCOMClient.Fields.Fields[i].FieldName +Chr(9); cdsHHBSCOMClient.Next; end; FieldNames := FieldNames + Chr(8); //////end Fields Name //////begin Fields Value FieldValues := ''; cdsHHBSCOMClient.First; while not cdsHHBSCOMClient.Eof do begin for i := 0 to cdsHHBSCOMClient.FieldCount - 1 do FieldValues := FieldValues + cdsHHBSCOMClient.Fields.Fields[i].AsString + Chr(9); FieldValues := FieldValues + Chr(8); cdsHHBSCOMClient.Next; end; //////end Fields Value Result := FieldTypes + FieldNames + FieldValues; end;
Table.fields.Fields[i].asString取值,
而后用stream写入openfile()打开的txt内
i: Integer;
FieldTypes: string;
FieldNames: string;
FieldValues: string;
begin
//////begin Fields DataType
FieldTypes := '';
cdsHHBSCOMClient.First;
for i := 0 to cdsHHBSCOMClient.FieldCount - 1 do
begin
case cdsHHBSCOMClient.Fields.Fields[i].DataType of
ftSmallint: FieldTypes := FieldTypes + 'Number'+ Chr(9);
ftInteger: FieldTypes := FieldTypes + 'Number'+ Chr(9);
ftFloat: FieldTypes := FieldTypes + 'Number'+ Chr(9);
ftCurrency: FieldTypes := FieldTypes + 'Number'+ Chr(9);
ftDate: FieldTypes := FieldTypes + 'DateTime'+ Chr(9);
ftTime: FieldTypes := FieldTypes + 'DateTime'+ Chr(9);
ftDateTime: FieldTypes := FieldTypes + 'DateTime'+ Chr(9);
else
FieldTypes := FieldTypes + 'String'+ Chr(9);
end;
cdsHHBSCOMClient.Next;
end;
FieldTypes := FieldTypes + Chr(8);
//////end Fields DataType
//////begin Fields Name
FieldNames := '';
cdsHHBSCOMClient.First;
for i := 0 to cdsHHBSCOMClient.FieldCount - 1 do
begin
FieldNames := FieldNames + cdsHHBSCOMClient.Fields.Fields[i].FieldName
+Chr(9);
cdsHHBSCOMClient.Next;
end;
FieldNames := FieldNames + Chr(8);
//////end Fields Name //////begin Fields Value
FieldValues := '';
cdsHHBSCOMClient.First;
while not cdsHHBSCOMClient.Eof do
begin
for i := 0 to cdsHHBSCOMClient.FieldCount - 1 do
FieldValues := FieldValues + cdsHHBSCOMClient.Fields.Fields[i].AsString
+ Chr(9);
FieldValues := FieldValues + Chr(8);
cdsHHBSCOMClient.Next;
end;
//////end Fields Value Result := FieldTypes + FieldNames + FieldValues;
end;