Forms4 boilerplate accessible?

3 views
Skip to first unread message

Doug Thomson

unread,
May 3, 1994, 9:43:46 AM5/3/94
to
Forms4 question:

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.

Steve Muench of Oracle - are you out there?
I'll bet you could tell us.

thanks for any suggestions - - -

DT

--
========================================================
Doug Thomson Fourth Shift / JIT
tho...@fs.com 7900 International Drive
(612) 851-1471 Minneapolis, MN 55425 USA

Glenn Nicholas

unread,
May 4, 1994, 8:15:06 AM5/4/94
to
In article <Cp8BG...@cardinal.fs.com>
tho...@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.

Martin Jensen

unread,
May 5, 1994, 2:58:02 AM5/5/94
to
tho...@bluebird.fs.com (Doug Thomson) writes:

>Forms4 question:

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

When storing the form in the database, all presentational literals
(as well as bitmaps I think) are stored in the ROS tables
(Resource Object Store).
Unfortunately the literals themself get stored in the table: rosstrings
in the LONG RAW field str in Hex code,
so it is rather difficult to search for an applikation using a certain literal
not to mention changing the value to support an other language.

Oracle tels us however that a new product replacing NLS-Workbenck
called something like Translation Manager, could do the job

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

Would sure be nice.

>Steve Muench of Oracle - are you out there?
>I'll bet you could tell us.

>thanks for any suggestions - - -

Hope this helps.

>DT

>--
>========================================================
>Doug Thomson Fourth Shift / JIT
>tho...@fs.com 7900 International Drive
>(612) 851-1471 Minneapolis, MN 55425 USA

--
Martin Jensen, Dansk Data Elektronik A/S, Herlev, Denmark
E-mail: ..!uunet!mcvax!dkuug!dde!mj or m...@dde.DK
---
Don't take life too seriously -- you'll never get out if it alive.

Reply all
Reply to author
Forward
0 new messages