XLATE and Sorting (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 15 FEB 2005 04:40:50PM P Cotter wrote:

AREV Specific

We have a WINDOW, which display all orders for a specific item, whether they are filled or unfilled.

Recently we have reset or order nos from 99999 to 10000, this has created a problem in that the 10000 order numbers are now appearing below the 99999 numbers.

Is there any way to change the sort sequence on a WINDOW.

We have the statement

@ANS=XLATE( "ORDER" , {ORDER.NOS} , "DATE" , "X")

We would like the WINDOW to display the result of this in either DATE order or ORDER.NOS order.

Can anyone help me achieve this.

Thanks

Peter

At 15 FEB 2005 06:40PM dsig _at_ sigafoos.org wrote:

you could modify your dict to use v119 before returning ans. this will sort your return values however you want to sort them.

The arev book has something in system subroutines as I remember.

dsig _at_ sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

At 16 FEB 2005 06:40AM The Sprezzatura Group wrote:

Documentation for V119 is available in the Sorting using V119 (TB#38) document in the online knowledge base.

The Sprezzatura Group

World Leaders in all things RevSoft

At 16 FEB 2005 08:20AM Warren Auyong wrote:

You can use my AMV_SORT routine which is a shell around V119 so that you can easily sort AMV data. Limit is 64K due to passed parameters. Post an email and I'll send you a copy.

At 16 FEB 2005 10:58AM Paxton Scott wrote:

HI,

Are you sure the order_number is right justified in the dictionary?

[email protected]

[url=http://www.arcscustomsoftware.com]ARCS, Inc.

View this thread on the forum...