language caption quering OBDC -SQL

Manolo_SPA
Manolo_SPA Member Posts: 19
edited 2008-07-31 in SQL General
Hi to everybody:
I upgraded a customer from native to SQL and he was using native ODBC.
right now he can use but all the caption fields are in english, and he wants them translated in Spanish ("as it was before upgrading").

I have read a post by waldo, suggesting about "maintain views", but when I click it, I get an error in User Table saying that password field already exits in the same table (it doesn't).

Does anyone knows about this error or how can i manage to get translated captions.

Regards

Answers

  • kine
    kine Member Posts: 12,562
    Check the table. It seems that two fields have same ESP caption. Each field need to have different caption in one table...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • amunozsu
    amunozsu Member Posts: 30
    Hello,

    Try this: in "Navision ODBC Setup" click "Options" and change Language to Auto or Spanish.

    -- Alejandro --
  • kine
    kine Member Posts: 12,562
    amunozsu wrote:
    Hello,

    Try this: in "Navision ODBC Setup" click "Options" and change Language to Auto or Spanish.

    -- Alejandro --

    It is about SQL ODBC, not N/ODBC (C/ODBC)... :wink:
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • amunozsu
    amunozsu Member Posts: 30
    Sorry, I must read before reply :(
  • Manolo_SPA
    Manolo_SPA Member Posts: 19
    Posted: Sun Jul 27, 2008 11:38 pm Post subject:

    Check the table. It seems that two fields have same ESP caption. Each field need to have different caption in one table...

    Finally there was two fields with same caption. Renaming the field, I could create views.

    Thanks.

Categories