Another way to do it that involves more SQL but less Livecode is set the text of button xyz to revDataFromQuery(,,gDBID,"SELECT <datacolumn> FROM <tablename> ORDER BY <datacolumn>")
set the cKeys of button xyz to revDataFromQuery(,,gDBID,"SELECT <keycolumn> FROM <tablename> ORDER BY <datacolumn>") I think I like that better, simpler and not likely to be be noticeably slower. Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sat, Feb 7, 2015 at 8:21 AM, Pascal Lehner <[email protected]> wrote: > Hi Pete and Klaus, > > thanks for your quick answer! > Since my items are not in a sequential number I will adapt my code to > Pete's example. > > Have a great weekend! > > Pascal > > > > 2015-02-07 16:47 GMT+01:00 Peter Haworth <[email protected]>: > > > Hi Pascal, > > After selecting the data from your db, do this > > > > command createKeys pdata,pid > > --pdata is tab delimited data from revdatafromquery > > -- item 1 is the key, item 2 is the display data > > --pid is the long id of the menu button > > > > local tKeys,tText > > > > set the itemdelimiter to tab > > repeat for each line rLine in pdata > > put item 1 of rLine &return after tKeys > > put item 2 of rLine & return after tText > > end repeat > > set the text of pid to tText > > set the cKeys of pid to tKeys > > > > end createKeys > > > > on menuPick pitemname > > --use the menuHistory to access the cKeys cprop > > > > put pitemname into field xyx > > put line the menuHistory of me of the cKeys of me into field abc > > > > end menuPick > > > > Pete > > lcSQL Software > > On Feb 7, 2015 7:18 AM, "Pascal Lehner" <[email protected]> wrote: > > > > > Hi all, > > > > > > I use menuPick to have a button with a drop down menu. The menu items > are > > > loaded from a database and the users selection needs to be stored back > > > there too. > > > > > > the dropdown list looks as following (id, name) > > > 1, full > > > 2, half full > > > 3, empty > > > > > > I save the users selection in two fields on the card > > > item 1 in a hidden field ( to be stored in the database record) > > > item 2 is displayed in another field > > > > > > obviously, the dropdown list does not look very nice like this. Even > more > > > so when I look at a real-world example with several words for "name" > > > > > > Can you think of a way to display only the "name" in the dropdown list, > > but > > > still save the id in the hidden field? > > > > > > Thanks, > > > Pascal > > > _______________________________________________ > > > use-livecode mailing list > > > [email protected] > > > Please visit this url to subscribe, unsubscribe and manage your > > > subscription preferences: > > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > _______________________________________________ > > use-livecode mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
