[Gambas-user] Retrieve database records

[Linux Power]

Hi all,
  I have the following question for anyone that has some spare time to have 
a look on this...

Lets assume we have the following table in a database:
COLOR   <-- Table Name
Color_id  <-- Key Value
NAME     <-- Color Name Records

---- let records be ---
black
blue
red
yellow
--------------------------

and assuming that:
PUBLIC db AS NEW Connection
PUBLIC rs AS Result

-- somewhere else on the code --
DIM sQuery AS String
sQuery = "SELECT NAME FROM COLOR"
rs = db.Exec(sQuery)

If the connection to the database was successfull. How do I load the records 
in a combo box (ie. ComboBox1)?

Tnx in advance

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/