Accessing items returned from a SQL query

[rhysmeister]

I am using Delphi to access a SQl server DB. Just having a little trouble accessing the results from a SQL statement (which appears to run well). I want to put them onto a label on a form. Here is my code so far...

Close; // Close any present DB connection
SQL.Clear;
SQL.Add('SELECT * FROM ACI_Errors WHERE ID = (:SelectedParam)');
// Get the index of selected row adding 1
ParamByName('SelectedParam').AsInteger := DBGrid1.SelectedIndex + 1;
ExecSQL; // Execute the SQL

 

[DaZZleD]

ok... then continue with

Open;
First;
while not eof do
begin
  Label1.Text := Label1.Text + ', ' + FieldByName('field_name_to_display').AsString;
  Next;
end;
Close;

ofc this code is just a simple example and that you need to change it to suit your needs, but at least will give you a start

 

[DaZZleD]

remove the ExecSQL() statement

ok... then continue with

Open;
First;
while not eof do
begin
  Label1.Text := Label1.Text + ', ' + FieldByName('field_name_to_display').AsString;
  Next;
end;
Close;

ofc this code is just a simple example and that you need to change it to suit your needs, but at least will give you a start

 

[rhysmeister]

Excellent, works a treat!