Filling Combo Box from Database

[Devin Asay]

On Feb 21, 2007, at 1:27 PM, Dave Ingledew - WCS wrote:

> 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

Dave,

Once you have the list in the format you want it, just do this:

put myList into btn "myComboBox"

HTH

Devin


Devin Asay
Humanities Technology and Research Support Center
Brigham Young University