Filling Combo Box from Database

[Klaus Major]

Hi Dave,

> Hi All,
>
> Please be patient with me, I started programming (exploring)  
> Revolution a few days ago. I'm not an inexperienced programmer,  
> nearly 30 years with C, Informix, SQL WIndows and a bit of VB. But  
> I'm still finding some of Revolutions syntax a bit strange. I love  
> it though and I hope to use it lots in the future.
>
> I'm trying to fill the menu or list items of a ComboBox with items  
> selected from a database.
> I've sorted out the database connection, opening the database,  
> executing the SQL that selects the data and then using a While -  
> Repeat loop to step through the dataset and displaying the data a  
> record at a time with answer. So far so good but how on earth do I  
> get this data into the ComboBox.
>
> The best indication I found lurking in the description of the  
> ComboBox was to use the "Text" property.
>
> I've trawled the email Archive back to last August and though I've  
> found a few ideas, which are going to be very helpful, nothing that  
> helps with this.
>
> If anybody can help I would be most grateful

this is dead simple, just "put" your list into that button :-)

...
put your_list_from_the_DB into btn "your combo box"
...

Will do the trick, assumed in your_list_from_the_DB is a valid CR  
delimited list.

> Dave Ingledew
> dave at westcomp.co.uk
> www.westcomp.co.uk

Regards

Klaus Major
klaus at major-k.de
http://www.major-k.de