mibuso.com

Microsoft Business Solutions online community
It is currently Wed Jul 23, 2014 3:11 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Navision SQL table names
PostPosted: Wed Oct 13, 2010 9:25 am 
Offline

Joined: Tue Apr 13, 2004 10:52 am
Posts: 65
Location: Scotland
Country: United Kingdom (uk)
Hi,

I need to access Navision tables for reporting purposes and other than . being converted to _ as in "CRONUS UK Ltd." becoming "CRONUS UK Ltd_" are there any other character conversions to consider.

Thanks
Roddy


Top
 Profile  
 
 Post subject: Re: Navision SQL table names
PostPosted: Wed Oct 13, 2010 10:25 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Jul 19, 2005 4:49 pm
Posts: 4175
Location: Olst
Country: Netherlands (nl)
Have a look at File -> Database -> Alter and then the Integration Tab.

Here is a field called Remove Characters. These are replaced by an '_'.

There is also somewhere a SQL script that you can download that converts the tablenames based on this but I can't recall where that was.

_________________
Mark Brummel | Freelance Dynamics NAV (Navision) Specialist

Author of the book : Microsoft Dynamics NAV Application Design

MY BLOG : http://markbrummel.wordpress.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: Navision SQL table names
PostPosted: Wed Oct 13, 2010 2:05 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Feb 03, 2006 10:15 pm
Posts: 2291
Location: Houston, TX
Country: United States (us)
/ are converted. & are not. In fact I think just . and / are converted.

_________________
Matt Traxinger - ArcherPoint
Microsoft Dynamics NAV 2009 Programming Cookbook
Do you have an idea to improve NAV? Submit it at I Love NAV


Top
 Profile  
 
 Post subject: Re: Navision SQL table names
PostPosted: Wed Oct 13, 2010 8:57 pm 
Offline

Joined: Fri Aug 06, 2004 9:30 pm
Posts: 1050
Location: Richardson
Country: United States (us)
I don't know what the impact is on using queries and stored procedures on large databases, but you can define synonyms in SQL Server and use those instead of table names. I have found this useful when dealing with multi-company setups where only one person at a time is running reports.
I am guessing with a bit more work, I could find a way to make it multi-user.

_________________
David Machanick
http://mibuso.com/blogs/davidmachanick/


Top
 Profile  
 
 Post subject: Re: Navision SQL table names
PostPosted: Thu Oct 14, 2010 9:02 am 
Offline

Joined: Mon Dec 11, 2006 10:34 am
Posts: 2883
Location: Bergamo
Country: Italy (it)
just a funny thing...i think that some of you already tried to do this just to see what error is being generated :mrgreen:
create a table named "a.b" and then another table named "a/b"... :twisted:

_________________
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog


Top
 Profile  
 
 Post subject: Re: Navision SQL table names
PostPosted: Thu Oct 14, 2010 9:21 am 
Offline

Joined: Thu Apr 05, 2007 12:15 pm
Posts: 955
Location: Bochum
Country: Germany (de)
So, what is the result?

_________________
"Money is likewise the greatest chance and the greatest scourge of mankind."


Top
 Profile  
 
 Post subject: Re: Navision SQL table names
PostPosted: Thu Oct 14, 2010 9:36 am 
Offline

Joined: Mon Dec 11, 2006 10:34 am
Posts: 2883
Location: Bergamo
Country: Italy (it)
Quote:
The a/b table name conflicts with an existing SQL Server object company.dbo.company$a_b.

You must choose another table name or set the LinkedObject table property to Yes if you would like to link to this object.

for sure!

_________________
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog


Top
 Profile  
 
 Post subject: Re: Navision SQL table names
PostPosted: Thu Oct 14, 2010 9:44 am 
Offline

Joined: Thu Apr 05, 2007 12:15 pm
Posts: 955
Location: Bochum
Country: Germany (de)
Well, that is what I would expect.... I thought you're going to tell a new amazing story. :wink:

_________________
"Money is likewise the greatest chance and the greatest scourge of mankind."


Top
 Profile  
 
 Post subject: Re: Navision SQL table names
PostPosted: Thu Oct 14, 2010 9:55 am 
Offline

Joined: Mon Dec 11, 2006 10:34 am
Posts: 2883
Location: Bergamo
Country: Italy (it)
einsTeIn.NET wrote:
Well, that is what I would expect.... I thought you're going to tell a new amazing story. :wink:

no, unfortunately not an amazing story...sorry :roll:
hopefully none of us uses dots in table names [-o<

_________________
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog


Top
 Profile  
 
 Post subject: Re: Navision SQL table names
PostPosted: Thu Oct 14, 2010 10:01 am 
Offline

Joined: Thu Apr 05, 2007 12:15 pm
Posts: 955
Location: Bochum
Country: Germany (de)
Belias wrote:
hopefully none of us uses dots in table names [-o<

hehehe... I guess in this business only the sky is the limit. :wink:

_________________
"Money is likewise the greatest chance and the greatest scourge of mankind."


Top
 Profile  
 
 Post subject: Re: Navision SQL table names
PostPosted: Fri Oct 15, 2010 10:46 am 
Offline

Joined: Tue Apr 13, 2004 10:52 am
Posts: 65
Location: Scotland
Country: United Kingdom (uk)
Thanks for the barrage of replies :D Good Karma to you all.

Roddy


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 11 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: