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

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

Thank's Bob

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

View this thread on the Works forum...