procedure TForm1.Button1Click(Sender: TObject);
begin
with ADOQuery1 do
begin
SQL.Clear;
SQL.Text := 'Select Top 2 * FROM sysobjects';
Open;
while not(eof) do
begin
with ListBox1.Items do
begin
Add(fieldbyname('name').AsString);
Add(fieldbyname('xtype').AsString);
Add(fieldbyname('id').AsString);
Add(fieldbyname('uid').AsString);
end;
ListBox2.Items.Add(fieldbyname('name').AsString
+fieldbyname('xtype').AsString
+fieldbyname('id').AsString
+fieldbyname('uid').AsString);
Next;
end;
end;
ADOQuery.first;
listbox1.Items.clear;
while not ADOQuery.Eof do
begin
listbox1.Items.Append(ADOQuery.fieldbyname('name').asstring);
ADOQuery.next;
end;