mibuso.com

Microsoft Business Solutions online community
It is currently Tue Dec 23, 2014 5:19 am

All times are UTC + 1 hour




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

Joined: Tue Apr 13, 2004 9:52 am
Posts: 70
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 9:25 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Jul 19, 2005 3:49 pm
Posts: 4188
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

Read my new book: Microsoft Dynamics NAV 2013 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 1:05 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Feb 03, 2006 9:15 pm
Posts: 2292
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 7:57 pm 
Offline

Joined: Fri Aug 06, 2004 8:30 pm
Posts: 1075
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 8:02 am 
Offline

Joined: Mon Dec 11, 2006 9: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 8:21 am 
Offline

Joined: Thu Apr 05, 2007 11:15 am
Posts: 973
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 8:36 am 
Offline

Joined: Mon Dec 11, 2006 9: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 8:44 am 
Offline

Joined: Thu Apr 05, 2007 11:15 am
Posts: 973
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 8:55 am 
Offline

Joined: Mon Dec 11, 2006 9: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 9:01 am 
Offline

Joined: Thu Apr 05, 2007 11:15 am
Posts: 973
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 9:46 am 
Offline

Joined: Tue Apr 13, 2004 9:52 am
Posts: 70
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


Who is online

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