SQL server returns . as . not _ !

arnaroarnaro Member Posts: 29
edited 2008-06-20 in NAV Tips & Tricks

ran into a strange "problem" today. Ever since I started writing c# code against SQL server Navision databases I've had to replace . with _ such as "No." would be "No_".

Then today while installing at a client all off a sudden the SQL Server doesnt want the "No_" but gladly accepts "No." !!!!

Is there a setting on the server that does this or does anyone know how to tackle this otherwise than changing all the sql queries to use . instead of _ ?



  • ara3nara3n Member Posts: 9,253
    I've never changed this setting but on file->database->alter->Integration Tab

    You will find remove characters text box

    Is the Convert identifiers checked?
    Ahmed Rashed Amini
    Independent Consultant/Developer

    blog: https://dynamicsuser.net/nav/b/ara3n
  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    It is in the NAV setup under alter database.

    Reallly do not change it. We have some customers (3 if I am not mistaken) who have that running and it is a nightmare. SQL officialy does not support it. You can run into all kinds of ugly supprises.
  • arnaroarnaro Member Posts: 29
    Yes - I decided to change the SQL syntax rather than taking the chance on changing the server as this has to be up at all times.

    Thanks for the help tough - at least I know the cause now.
Sign In or Register to comment.