-- Here's using an array

put revDataFromQuery(tDataBaseID, "SELECT <displayItem>, <storeItem> FROM
<tableName>") into tArray
  -- Note that displayItem is what you want to display in the menu,
storeItem is the corresponding value you want to store; the data is not an
array yet.

split tArray by return and tab
  -- now, tArray has displayItem as the array key and storeItem as the array
element

-- Now you can display the keys of tArray in the menu in the order you like
-- and save tArray[chosenMenuItem] in the database.

Regards,
Sri.



--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/Use-MenuPick-properly-tp4688589p4688596.html
Sent from the Revolution - User mailing list archive at Nabble.com.

_______________________________________________
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

Reply via email to