language caption quering OBDC -SQL

Manolo_SPA

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

kine

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

amunozsu

Hello,

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

-- Alejandro --

kine

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)...

amunozsu

Sorry, I must read before reply

Manolo_SPA

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.