Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Retrieve data from Access Linked Table
iansilvers
Member Posts: 38
Looking for a bit of help here.
Our customer has an Access database which they want to be able to enquire on from within NAV. I have created a Linked Server in SQL for the Access database, and created a couple of views against it. I have created linked tables in NAV for each view. I have also created a couple of pages against these, and I can run both the table and the pages and see the data in Access. I can set filters on the page, and it all works as I would expect
The problem I have is that I am now trying to read the within a codeunit. I have following code
Collection.RESET;
IF Collection.FINDSET THEN
REPEAT
...
UNTIL Collection.NEXT = 0;
This consistently fails to return any records from the Access database, despite the fact that I can see them when I run the table and the page
The same happens when accessing the linked table via a report - I get no records returned.
I am using NAV2013 R2 with a SQL Server 2012 database.
Any help would be greatly appreciated
Our customer has an Access database which they want to be able to enquire on from within NAV. I have created a Linked Server in SQL for the Access database, and created a couple of views against it. I have created linked tables in NAV for each view. I have also created a couple of pages against these, and I can run both the table and the pages and see the data in Access. I can set filters on the page, and it all works as I would expect
The problem I have is that I am now trying to read the within a codeunit. I have following code
Collection.RESET;
IF Collection.FINDSET THEN
REPEAT
...
UNTIL Collection.NEXT = 0;
This consistently fails to return any records from the Access database, despite the fact that I can see them when I run the table and the page
The same happens when accessing the linked table via a report - I get no records returned.
I am using NAV2013 R2 with a SQL Server 2012 database.
Any help would be greatly appreciated
0