Database query results into Combo Box list

Sarah Reichelt sarahr at genesearch.com.au
Wed Jun 1 23:56:29 EDT 2005


> I want to populate a combo box (menu) with a list of items returned  
> from a
> database query. I can run the query OK, but how do I put the  
> results into the
> combo box menu? When I try using:
>
> get revQueryDatabase(...)
> put it into menu "RdNoMenu"
>
> I just get one single number in there, not the 1000 or so records  
> that would
> have been returned by the select statement.

Hi Rishi,

Welcome to the Revolution!

revQueryDatabase() returns the ID number of a cursor - a set of  
records which you can then list, manipulate, edit etc.
The easier solution is to use revDataFromQuery() which gives you back  
the actual record data.

Cheers,
Sarah



More information about the use-livecode mailing list