Re: Displaying both inches & metric numbers in a form?

How about this: could you display the values via a view that could be switched between inches and centimetres (imperial or American and metric)? The view could use packaged functions to do the conversion and the switch could be make by calling a procedure in a package to set a package global variable. This global variable could then be used to modify how the conversion takes place.

This method would mean that the conversion occurs before the data reaches the Oracle Form. Even the 'cm'/'inches' label could be returned by the view.

There are a hundred and one ways to do this, so I will leave the doors open to other suggestions...

JJ

Douglas Scott <dsscott_at_ev1.net> wrote in message news:38445593.98ED82AF_at_ev1.net...
> I have a Sql*Forms 3.0 form that maintains a large number of
> measurements of the human body. Some of the measurements are taken
> using the English system (inches) and some are taken using the metric
> system (centimeters). The form uses non-base table fields to display
> the measurements (the base table fields are on page 0 or the NULL
> canvas) and a key that allows the user to toggle between inches and
> centimeters. The data is stored in the table in inches. There is quite
> alot of logic involved in doing the conversion. What I would like to do
> is re-create this form in Developer 6 and simplifiy the code required.
> Does anyone know of a way to do this?
>
> Douglas Scott
> dsscott_at_ev1.net
>
Received on Wed Dec 01 1999 - 02:18:32 CET