Display the Form with the previously set sort key

month8848 · 2010-05-12

Navision 2009, Native

When I pull up the From, I can Shift+F8 and change the default sort key. When I then close the Form, and re-open it,the previously set sort key is forgotten.

I want to display the Form with the previously set sort key.

How do I Save the sort key ?

lvanvugt · 2010-05-12

Well, you challenged me (as I was not sure) so I tried the following:

1. Open Chart of Accounts (COA)
2. Choose a new (sort) key, being (in w1) the last key: Name
3. Applied it
4. Closed COA
5. Reopend COA

Result:
COA is still sorted by the Name key!

Even when I close NAV, restart and reopen COA it's still sorted by the Name key!

So this seems to do exactly what you are asking for. I wonder if the form you have worked with maybe has a key set by means of code or the SourceTableView property. In that case the sorting will always 'revert' to this setting when you reopen the form.

einsTeIn.NET · 2010-05-12

It depends on your form. Maybe it's called by code and there is a special key assigned by SETTABLEVIEW. Or on the form itself there is this property SourceTableView, maybe that's set. In general there is another property to store the users view in the zup file: SaveTableView. Try this one.

rdebath · 2010-05-12

Sure you want to just save the key?

How about this: http://www.mibuso.com/dlinfo.asp?FileID=895

KYDutchie · 2010-05-12

Hi,

I believe there are properties on the form for that.
Aren't the SaveTableView and SaveValues used for this purpose?

Thanks,

Willy.

Savatage · 2010-05-12

Also check there is no
RESET;
on the form. (onopen, onclose, etc)

month8848 · 2010-05-13

I have find the reason , when i open the Form used lookuptable that select records by primay key.
I change it the RunObject then Form display the records by pervious sort key has be saved .

Display the Form with the previously set sort key

Comments

Categories