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.
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.
just a funny thing...i think that some of you already tried to do this just to see what error is being generated
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
Comments
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.
My Blog - nav.education
I am guessing with a bit more work, I could find a way to make it multi-user.
http://mibuso.com/blogs/davidmachanick/
create a table named "a.b" and then another table named "a/b"... :twisted:
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
hopefully none of us uses dots in table names [-o<
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
Roddy