About Identifiers

andy76
Member Posts: 616
Hello,
I ask you if there is some relationship between the field Identifiers in DB SQL Server under File->Database->Alter , Integration Tab Convert Identifiers / Remove Character and the Field Identifiers under ODBC Setup - Options that is an option between All Except Dot, All Characters, All Except Space, "a-z,A-Z,0-9,-".
Thank you
I ask you if there is some relationship between the field Identifiers in DB SQL Server under File->Database->Alter , Integration Tab Convert Identifiers / Remove Character and the Field Identifiers under ODBC Setup - Options that is an option between All Except Dot, All Characters, All Except Space, "a-z,A-Z,0-9,-".
Thank you
0
Comments
-
Because C/ODBC is used for Nativeand Integration tab in Alter Database is only for MS SQL server, there is no direct connection. The only connection is, that ODBC specification is not allowing some characters as part of the object name (or some clients cannotwork with these characters). Thus both tools have some way how to "remove" these characters...0
-
[Topic moved from Navision forum to SQL General forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!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