Showing A Distinct Number 1

[patlim88]

I have a combo box that displays everything in field 'BACKGROUPNUMBER'. For example if there is 100 groupnumbers of 20020620052401 and 100 groupnumbers of 20010511231408 when I click on the combo box I see all two hundred numbers. The folowing code illustrates this:

procedure TForcedCall.FormCreate(Sender: TObject);
begin

// code below will list all the Group numbers in the drop down box

CallBackQ.Close;
CallBackQ.Prepare;
CallBackQ.Open;

CallBackCB.items.clear;
CallBackQ.Open;

while not CallbackQ.eof do

begin

CallBackCB.Items.Add(CallbackQ.Fieldbyname('BACKGROUPNUMBER').asstring);
CallBackQ.next;

end;

Is there a way to only show the two group numbers 20020620052401 and 20010511231408 in the combo box?

Thanks.

 

[McMerfy]

Add "DISTINCT" to your select SQL statement. F.ex. :
SELECT DISTINCT BACKGROUPNUMBER FROM MYTABLE

--- markus

 

[patlim88]

That worked!

Thanks.