Use MenuPick properly

[Peter Haworth]

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 <tate83 at gmail.com> 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 <pete at lcsql.com>:
>
> > 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" <tate83 at gmail.com> 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
> > > use-livecode at lists.runrev.com
> > > Please visit this url to subscribe, unsubscribe and manage your
> > > subscription preferences:
> > > http://lists.runrev.com/mailman/listinfo/use-livecode
> > >
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>