I have a file with a numeric key field, called NUMBER. The dictionary for NUMBER is defined as right aligned.

In the popup I have: by number

However, details in the popup appear sorted left-aligned:

 1

 10

 11

 2

How can it be sorted numerically?

Kelly,

Assuming you design the popup with UI Workspace: On the Layout tab set Col Just for the numeric field to Right.

- Oystein -

Thanks, but in this particular case I would prefer not to display the key field.

If you created the popup via the UI Workspace you can sort by any column that you wish. For example, if you are using the "select rows from table" in the source area, you can specify the column to sort by in the selection area. Under selection criteria, type in BY NUMBER,or whatever field you wish to sort by. You can also try calling the popup via a program. Put your select list in the code prior to calling up the popup. Try this

RList("SELECT FILE_VAR WITH FIELD_VAR '":VAR:"'" ,5,"","","")

This particular command selects a file with the field_var=var.

The popup is then called. If you're familiar with AREV, you shouldn't have any problems with this.

Hope it helps.

André

André/Kelly,

Under selection criteria, type in BY NUMBER, or whatever field you wish to sort by.

But then you get a left-aligned sort, I think. To get around that problem you could sort on a calculated column which is a zero-filled right-aligned version of the NUMBER column.

- Oystein -

Kelly,

If you call RLIST from the command line with a similar statement, what are the results. Example:

run RLIST "LIST BY NUMBER", 1

Cameron Purdy

Revelation Software

View this thread on the forum...