Is there a way to find table ID bas on tablename
 
            
                
                    Resender                
                
                    Member Posts: 119                
            
                        
            
                    Hello,
I've gotten an intresting question, we got 2 tables with the same name, diffrent ID off couse.
We now are getting unexpected behavior from a codeunit that uses 1 of these 2. We suspect that the record variable is pointing to the wrong one.
When we look into the global/local variables we get offcourse the variable name, its type (Record) and its susbtype, I want to know if there's a way to determine what the ID is of the table in the subtype
Thank you
                I've gotten an intresting question, we got 2 tables with the same name, diffrent ID off couse.
We now are getting unexpected behavior from a codeunit that uses 1 of these 2. We suspect that the record variable is pointing to the wrong one.
When we look into the global/local variables we get offcourse the variable name, its type (Record) and its susbtype, I want to know if there's a way to determine what the ID is of the table in the subtype
Thank you
0                
            Comments
- 
            
 Is it in database?Resender wrote:we got 2 tables with the same name, diffrent ID off couse.
 It wont allow you to have objects with same name..0
- 
            And yet I'm seeing 2 tables with exactly the same name, they got a diffrent caption.
 A secondary problem is the mix between the use of the dutch or english names for tables by our people.0
- 
            
 What is the NAV version you are using? In the earlier NAV versions, it was possible to have 2 objects of the same type, with the same name. Why don't you add an "X" to one of the table names, and then see in your code which variable points to which table?Resender wrote:And yet I'm seeing 2 tables with exactly the same name, they got a diffrent caption.No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)0
- 
            Using navision attain BE 3.60 (3.60)0
- 
            When I open Table 3 in Design Mode, and save it with object number 50003 (without changing the name), I got this error in BE 3.60:
 "The object name already exists.
 Existing object: Table 3 Payment Terms
 New object: Table 50003 Payment Terms"
 So I'm unable to create 2 tables with the same name.No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)0
- 
            Maybe there's an additional blank space within the name of one Object or something like that."Money is likewise the greatest chance and the greatest scourge of mankind."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
- 323 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


