Sort Order 'Stickyness'

bhalpin

Hi.

On a customer card, pressing [F5] brings up the Customer List.

On a local db, if I change the sort order of the list to something like 'Search Name', the choice sticks through multiple pick operations, and even afterclosing and reopening NAV.

But, on an SQL NAV database, the sort order seems to be reverting back to "No." after any pick.

Is there some option I'm missing? Or, is this one of the small differences when running on an SQL db?

Thanks in advance.

Savatage

What do you mean by "multiple pick operations"

F5->Sectect A Customer
F5->Select another
etc etc???

bhalpin

Yes.

F5, pick a customer
F5, pick another.
as you said.

Savatage

And these are two different databases? correct?

Do they have different SourceTableView or SaveTableView properties?

Also are there any SETCURRENTKEY OnOpen as far as you know?

bhalpin

Same database.
Stock 5.0 SP 0 objects.

DenSter

I'm on SQL Server and it keeps the sort order just fine.

Perhaps you have some set of standard "enhancements" like a standard starter database that you always start with for every customer, in which there's a SETCURRENTKEY command in OnAfterGetRecord or something like that?