mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 1:31 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: SQL server returns . as . not _ !
PostPosted: Mon Jun 16, 2008 4:46 pm 
Offline

Joined: Mon Feb 25, 2002 8:01 am
Posts: 18
Hi,

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 _ ?

Regards


Top
 Profile E-mail  
 
 Post subject:
PostPosted: Mon Jun 16, 2008 6:26 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
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?

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jun 16, 2008 8:14 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Tue Jul 19, 2005 4:49 pm
Posts: 3838
Location: Olst
Country: Netherlands (nl)
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.

_________________
Mark Brummel | Freelance Dynamics NAV (Navision) Developer
Author of the book : Microsoft Dynamics NAV 2009 Application Design

MY BLOG : http://www.brummelds.com


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Fri Jun 20, 2008 2:40 am 
Offline

Joined: Mon Feb 25, 2002 8:01 am
Posts: 18
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.


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: