CODBC and VB HELP!

CWR
CWR Member Posts: 3
edited 2004-07-20 in Navision Attain
I've read several posts on CODBC and there seems to be some conflicting info on wether or not you can read AND write to the navision database. We have a CSide Nav DB and I have created a dataenvironment in VB and can read the tables just fine. I have removed the "read only" check box in the CODBC DSN configuration, but I cannot change a record in datagrid, and I've confirmed that "allow update" is checkmarked in the datagrid's properties. So is writing to Nav DB via CODBC just not possible? or am I missing something?

Thanks

Comments

  • CWR
    CWR Member Posts: 3
    Ok, you CAN write to a Nav table, it's just VERY picky...the SQL expression in the Dataenvironment has to be written just right. I can't seem to create very complex queries and joins though...I get "insuffiecient key column..." error. anyway....getting there, sorta.

Categories