CaptionML in Sqlserver

vpetrantoni

Hi everybody!

I'm writing an external tool in .net to read a Sql Nav DB, is somebody know where Navision store the value of the captionMl Field's property, in wich sql server Table ???

I found the "Object Translation" table but is empty !!!?

Thanks,

Miklos_Hollender

Just turn on Maintain Views in File / Alter Database and you'll get nice SQL views for table for every language you have installed.

derek

Thanks for great tip.

Another question about multilanguage: is there any table or view where I can find OptionCaptionML's for option values on SQL server?

I found data values (0,1,2,..) on views field, but is there any table relations for this data?

_Derek

kine

No, there is not such a table, but you can find solutions for that on this forum (and I thing that it was on Jörg's blog) how to do a batch in NAV which will export all ML captions for options into some proprietary table...

derek

Thanks for information.

I don't find any suited solutions for my purpose, so it's better that I don' t spend anymore time for this one.

My vision was create sql clause, where I can get these MLcaption's and then put them on a report.
Because there is no easy way, it is more straightforward to do these option caption's to report itself.

Probably I need these option caption's one or two time of ten reports and these changes take one or two minutes.

alex9

Is there any other way to access CaptionML values dynamically, except of MaintainViews option or populating custom NAV table?
What is the possible solution if we need to expose NAV data externally and use corresponding captionML for the fields?