Accessing Navision table name with spaces from .Net via ODBC

amankakar

I am trying to accces a table called shipment lines from .net via odbc in Nav 3.10 A .I am writing a insert query as
Insert INto [shipment lines] VALUES ('test')

It is giving LExical element Values not found

Waldo

I don't know what's wrong, but a can't help myself to reply to you that I would never insert records through ODBC straight into a standard NAV table ... . Do it with a temporary table, and let NAS handle the VALIDATE's and other triggers... .

amankakar

Can you explain a little bit more ,as to how to do this.I dint understand this temporary table thing

Waldo

May be I used the wrong word.

What I mean is to create your own "dumb" tabel, with no validation code or other business rules behind it. Do you inserts in those tables, and afterwards, use a NAS process to process these records into your standard NAV database.

NAS is able to execute business logic, and your third party application (using C/ODBC) is not...