如何根据表中一列的名字获取他这列的所有值?
for k := 0 to ClientDataSet1.RecordCount - 1 do
for j := 0 to ClientDataSet1.FieldCount - 1 do begin
Memo1.Lines.Add(ClientDataSet1.Fields[j].asstring);
end;
这是遍历表中所有值得方法,那么如果是根据ClientDataSet1.Fieldbynames(id)来获取id列的所有值如何实现?
for k := 0 to ClientDataSet1.RecordCount - 1 do
for j := 0 to ClientDataSet1.FieldCount - 1 do begin
Memo1.Lines.Add(ClientDataSet1.Fields[j].asstring);
end;
这是遍历表中所有值得方法,那么如果是根据ClientDataSet1.Fieldbynames(id)来获取id列的所有值如何实现?
for k := 0 to ClientDataSet1.RecordCount - 1 do begin
Memo1.Lines.Add(ClientDataSet1.Fieldbynames(id).asstring);
ClientDataSet1.Next;
end;
最好用while 循环
ClientDataSet1.First;
while not ClientDataSet1.eof do begin
Memo1.Lines.Add(ClientDataSet1.Fieldbynames(id).asstring);
ClientDataSet1.Next;
end;