Accessing Navision table name with spaces from .Net via ODBC

amankakar
amankakar Member Posts: 44
edited 2007-03-05 in Navision Attain
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

Comments

  • Waldo
    Waldo Member Posts: 3,412
    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... .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • amankakar
    amankakar Member Posts: 44
    Can you explain a little bit more ,as to how to do this.I dint understand this temporary table thing
  • Waldo
    Waldo Member Posts: 3,412
    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...

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog

Categories