can C/ODCB refer to table and field names ?

Gerd
Gerd Member Posts: 2
edited 2004-02-26 in Navision Attain
I connect via C/ODBC to different Navisison-Databases in Germany, Austria and W1, so the table captions and field captions for the same tables are changing.

Is is possible to refer to table- and field names, or better to table and field ID´s?

Thanks for any idea
Gerd

Comments

  • martienlange
    martienlange Member Posts: 3
    This is possible in al least the following way

    Put in your C/ODBC settings (button Options) the language to Neutral.
    Then you canyou in all languages the English captions in your SQL statement.

    Furthermore it is advisable to use A-Z, a-z, 0-9 so that all different characters in the fieldnames are replaced by underscores.

    These are my experiences coupling hand held radio terminals to Navision through C/ODBC.

    Martien Lange

Categories