{{tag>category:"OpenInsight 32-bit" author:"Anders Lindholt" author:"bob carten"}}

[[https://www.revelation.com/the-works|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: ===
 
 
<QUOTE>
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
</QUOTE>
----

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

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

</QUOTE>

----

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

<QUOTE>Thank's Bob



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



</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=F98CECD6BF54AF6F637BD344B|View this thread on the Works forum...]]