I'm using XListValues in a combo box to have an element look into itself for previously entered values.  I've successfully retreived the values, sorted them numerically, and stripped out duplicates.  Now I'm wresting with the presentation of the retreive: all those zeroes following the decimal point.

The field is formatted as no decimals, and when I choose a value it presents it as such.  But the drop down still shows the zeroes.  Which string function/command do I need to use to get them to look "right"?

Here's my current code:

//Populate the first LIFTING CAPACITY combo box with a list of Capacities


Var vCapacities as String
Var vSort as string

vCapacities = @XListValues(@FN, "WORKORDR!LIFTING_CAPACITY_1")


// Sort data numerically
vSort = @SortStringArray(vCapacities, 1)


//Remove leading blanks - Empty Records
vSort = @Replace(vSort, ";;", "")

If @Lt(vSort, 1) = ";" then
	{
	vSort = @replfir(vSort, ";", "")
	}


// Remove duplicate entries, if any
vSort = @UniqueStringArray(vSort)


//Make the Combo Box List
PopulateListElement(LIFTING_CAPACITY_1, vSort) 

Thanks Ray.  That looks a bit more complex than I expected, but I'll play with it.

OK, it's working, thanks!  Still need a few tweaks, though.  The results are sorted as if alphabetically, and the box appears in the upper right corner of the screen.  I've seen the positioning issue mentioned elsewhere, but I forget where.  I'll find it eventually, it's really not a big deal.  Is it possible to put the results in the regular drop-down (like a standard combo box) instead of an @UserSelect box?

Sorting numerically would be a big boost, though.  Right now my results appear as:
Quote:

and so on.

Also, the element is acting funky when I try to select it a second or third time.  Click-and-click again doesn't work, but click-click somewhere else-click again does.  Is this a focus issue?  Should I throw focus off of it as soon as a selection is made?

You can use a combo box. Just use PopulateListElement to populate it with the list instead of displaying the list as a popup.

As for the click and click issue. What event are you running this on and what kind of element. If it is on entry of a text box element then yes you have to click elsewhere to get it to fire again as you are already in that element.

Make sure that you are using the 1 argument for @SortStringArray(). 1 is a numeric but a 0 is ASCII sort.

PopupSelectPosition() page 200-201 of the 1.1 Programming Guide

-Ray

Quote:


This is very useful and informative.  I can couple this with ThisElement to place the popup box over the element.

In the "Scope" section on page 200 it says that this command has no effect on Combo Boxes.  Is there a command that can be used with Combo Boxes?  Here's my situation; some of my Combo Boxes contain/retreive selections that are a few dozen characters long.  When chosen, my programming changes the string into a single character (or maybe 3 or 4).  For instance, if the user selects "Single-Drop Semi Trailer with Dock Levelers and Winch" the programming changes the element's stored value to "SDLW" to be used elsewhere in the programming.

So when all is done the Combo Box only needs to be wide enough to hold a few characters.  But to display the full selections to to user, I need to make it wide enough to show the full text.  Is there a command that will temporarily expand the size of the Combo Box while the selections are being shown, and then shrink it back down again once the selection is made?

Not yet, but I will!  Thanks.

Scott,

What do you mean by it is empty? Do you mean that the list does not appear, or the list appears but it is empty?

-Ray

Move Your X Pos by 218, the same as you are changing the width, to the left in the same section of code. This way the box appears to expand out to the left instead of out to the right. So the Drop down arrow for the combo box will stay under the mouse instead of jumping off to the right.


ex: If element was 110 wide and X Pos was 145 then:

Width(ThisElement, 220)
XPos(ThisElement, 35) 

-Ray