Options

Sorting a dataset on a column which is not a part of a key?

northyennorthyen Member Posts: 14
edited 2013-09-28 in NAV Three Tier
Hello!

The question is quite simple, I'm searching for a way to sort a dataset (which have been selected by SETRANGE etc.) - but so far it seems you have to setup and use a key. Is that really true? Any clever work arounds?

Coming from a SQL world, it boggles my mind, as I can easily do that, by using ORDER BY.

Comments

  • Options
    geordiegeordie Member Posts: 655
    If it's a RTC report you can also set the table "Sorting" property in Visual Studio layout, using a non-key field.
  • Options
    lvanvugtlvanvugt Member Posts: 774
    geordie wrote:
    If it's a RTC report you can also set the table "Sorting" property in Visual Studio layout, using a non-key field.
    True.

    The questions is: why would you want to sort your dataset as this can be easily handled in the "layout"?
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
Sign In or Register to comment.