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, PHP 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

take care that the data you want to put into a menu are in CR  
delimited list format,
one "menu item" per line. Then you can simply "put" the data into the  
button!

...
put my_formatted_DB_data into btn "my combobox"
...

That's it :-)

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

Best

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