I would like to have a Command Button for sorting a result set following a retrieve. I have created the element for the Command Button and programmed it using saved sort specs - see below.

Var vSort as String
var vSort1 as String
var vNav as Int

// Offer User Choice of Sort. Popup is placed directly over Sort button

     PopupSelectPosition(4, @XPos(cmd_Sort), @YPos(cmd_Sort))
     vSort = @PopupMenu(" ;Title;Author;Publisher","Which Way Do You Want to Sort?")

// Create the SelectTreeItem statement
     
     vSort1 = "Search Update Menu!Results Commands!Sort!BookIndx!" + vSort + " (Preview)"

//Run the SelectTreeItem Command

           vNav = @SelectTreeItem(vSort1)

It doesn't work.

Any ideas?

Hello Paul,

Try something like

 Var vSort as String
var vNav as Int

// Offer User Choice of Sort. Popup is placed directly over Sort button

 PopupSelectPosition(4, @XPos(cmd_Sort), @YPos(cmd_Sort))
 vSort = @PopupMenu("Title;Author;Publisher","Which Way Do You Want to Sort?")

vNav = @LoadSortSpec(vsort)
vNav = @SelectTreeItem("Search Update Menu!Results Commands!Sort") 

This assumes that you have Sort specs named "Title", "Author", and "Publisher".

-Ray