CFront .NET problem sample application

Peter_Wijntjes
Member Posts: 28
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!
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!

Peter Wijntjes
MBS NAV Consultant
MBS NAV Consultant
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions