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
- 310 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
CODBC Question
barondense
Member Posts: 5
Hello and good day to you all. I'm new here, so I don't know you, but it seems that this place is full of good people so I'm happy to have found you.
I'm trying to code a procedure that dumps certain data from the Native Attain database to an access database. The database I'm working on is the danish version so table and field names are in danish. The version is 3.70.
When I look at the data through linked tables in access, some of them show up twice (activity, personel etc..) When looking through the SQL server Import/export util, it looks like one is a table and one is a view. but I can't seperate the two using code. When use the ADO openschema and look at tables, they each show up twice with TABLE as the type.
I could make it work by hardcoding some stuff, but I would like to make generic code. So if anybody has some insight into how to catch what is a view and what is a table in the database through CODBC, I'd be very happy
Thank You
Bo
I'm trying to code a procedure that dumps certain data from the Native Attain database to an access database. The database I'm working on is the danish version so table and field names are in danish. The version is 3.70.
When I look at the data through linked tables in access, some of them show up twice (activity, personel etc..) When looking through the SQL server Import/export util, it looks like one is a table and one is a view. but I can't seperate the two using code. When use the ADO openschema and look at tables, they each show up twice with TABLE as the type.
I could make it work by hardcoding some stuff, but I would like to make generic code. So if anybody has some insight into how to catch what is a view and what is a table in the database through CODBC, I'd be very happy
Thank You
Bo
0