🚀 go-pugleaf

I had a similar problem... made a query and then wanted to
fill a combobox with the found data in a column...
I guess there is for sure a much more elegant method, but
here is how I did it:
(If somebode has a better idea, plz post it - thanks...)

//--------------------------------------------------------------------------
--------
   //Make sure all CD's are displayed:
   AnsiString sqlStatement;
   sqlStatement = "SELECT * FROM CD";
   ADOQuery1->Close();
   ADOQuery1->SQL->Clear();
   ADOQuery1->SQL->Add(sqlStatement);
   ADOQuery1->Open();

   //Fill the combobox CD with values displayed in column1 (0 would be the
first one)
   int iRows = ADOQuery1->RecordCount;

   ADOQuery1->First();

   for(int i=0; i<iRows; i++)
   {
      if(i == 0)
      {
         //Items[1] means 2nd Column in DBGrid...
         ComboCD->Items->Add(DBGridCD->Columns->Items[1]->Field->AsString);
      }
      else
      {
         ADOQuery1->MoveBy(1);
         ComboCD->Items->Add(DBGridCD->Columns->Items[1]->Field->AsString);
      }
   }
//--------------------------------------------------------------------------
--------


Instead of filling a combobox you can fill your array...


Cheers

Alen

--
WEB: http://www.come.to/nostromo





"Richard" <ajyi@yam.com> wrote in message
news:3e1d93cd$2@newsgroups.borland.com...
> Hi all,
>
> Because I use recursive function to solve some problem. I need to copy the
> query result to local set and operate these data. How to do that? Is there
> any easy way to do that?
>
> Thanks
>
>