x* filer on primary kye in no editable form

zappy

Try it ... it does't work. Any solution?
For example Item List - try filter 1* on No., after it try Maximase adn Restore the form ...

einsTeIn.NET

I tried it, it works.
Go to Item Card -> F5 -> filter on No. -> maximize the form -> scale down the form -> the filter is still set.

Take a look at OnAfterGetRecord trigger of the Item Card.

SETRANGE("No.");

Maybe that's the problem.

zappy

Very important - it works on native db, but try it on MS SQL Server !!! If you set filter (not setrange - it works too, it must be special filter, try "X*") and the form must be noneditable - the best is list.

List of Items, try filter on Item.No. = 1* and you will see what happend.

kine

No problem for me...

I assume it is on MS SQL 2005 with NAV 4.00SP3 without update... if the nav freeze (you didn't described what it is doing in your case), it can be problem of "parameter sniffing" bug.