Re: Forms4 boilerplate accessible?

In article <Cp8BGy.LtG_at_cardinal.fs.com>

           thomson_at_bluebird.fs.com "Doug Thomson" writes:

:does anyone know whether, if the Forms4 form is stored in
:the database, the boilerplate text items are accessible
:somewhere? (e.g. "literals" next to enterable fields)
:This would be useful when an app needs to be
:translated into multiple languages, e.g. the boilerplate
:text "Customer:" must be translated into several languages.
:Maybe some of the translation could be automated.

This is a mystery to me. While it appears the FRM40_TEXT table is the answer, saving a form with boiler text does not seem to insert into this table. Even if it did, I cannot see how the FRM40_TEXT table would record details such as x/y coordinates and formatting information. So how does Forms do it? The FRM40_ITEM.itmlabeli field may be relevant here, although I don't know what the translatable strings table is.

I have a suspicion that wherever the text is stored in the database (and it must be somewhere), it may be in binary form. If you look at boilerplate strings in the .fmt file, they are in binary.

When (if) you find the answer to this problem, please let me know.

-- 
Glenn Nicholas.