Using the CFront .NET sample application I have a problem when filtering the key table.
It can be reproduced with the sample application (Navision 4 sp1).
When viewing the key table, putting a filter on the first field fails.
An exception is raised: 1246279
I do not have a clue what this means.
I have written a small program that reproduces this problem.
works like this,
I have used setFilter(..... 5) and setRange(... 5,5) to filter on the field tableno
a call to getView after either of these calls shows
SORTING(TableNo,No.) WHERE (TableNo = FILTER(5..5))
or
SORTING(TableNo,No.) WHERE (TableNo = FILTER(5))
recordCount gives a result of 0, but a record does exist (first key on field Code).
findFirst raises exception.
without filtering on this field or filter on other fields works fine!