, ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

sql data set Microsoft Dynamics NAV (OpenInsight 32-bit)

At 25 MAR 2013 10:52:17AM Anders Lindholt wrote:

Hi,

Iam trying to build connection between OI 9.2.1 and Microsoft Dynamics NAV where Microsoft Dynamics NAV is located on SQL server 2009 R2.

No problems if the field name is without space in names fx.

SELECT 

 timestamp,
 sagsnummer,
 klientnavn,
 saldo,
 datotid

from dbo.adv$case

but if the statement is :

SELECT 

 timestamp,
 sagsnummer,
 klientnavn,
 saldo,
 datotid
 file path

from dbo.adv$case

where file path is a field with space in, - oi are not able to read/write contens via dataset.

How to work around this problem ?

Thank's

Anders

At 25 MAR 2013 11:11AM bob carten wrote:

try brackets around the name, for example [file path]

At 25 MAR 2013 11:57AM Anders Lindholt wrote:

Thank's Bob

Tried " an it didnt Work. Will use [] later on to Night. Thank's anders

View this thread on the Works forum...