Outputting query results

[doorbreaker]

Hello,

I am doing the following query....

sqlquery2.Open;
sqlquery2.SQL.Clear;
sqlquery2.SQL.Add(
'select * from so_oem_lookup ' +
'where oemnumber = "'+oemnumber+'" ' +
'and sonumber = 112 ' +
'and qtyneeded = "'+inttostr(qty)+'" ');

How do I output the query results into a listbox??

Hope you can help

Chris Moore

 

[EricDraven]

You just need to run through the queries results adding them to your listbox.

sqlquery2.First;
Listbox1.Items.Clear;
repeat
  Listbox1.Items.Add(sqlquery2.FieldByName('YOURFIELD').AsString);
  sqlquery2.Next;
until sqlquery2.EOF = True;
sqlquery2.Close;

When your feeling down and your resistance is low, light another cigarette and let yourself go