About Identifiers

andy76

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

kine

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...

kriki

[Topic moved from Navision forum to SQL General forum]