Selecting columns using view

Hello,

I'm developing multilanguage application and I've got to keep values in database in 3 languages. Is it possible, to create a view, than select proper column depending on some global value?

That view will be used in Forms, so it must be read-write (I cannot change anything in Forms). I've created following view, but it's read-only:

create table test$ (t_id number(10),
                    t_desc_en varchar2(30),
                    t_desc_de varchar2(30),
                    t_desc_pl varchar2(30));

create view test as
  select t_id, t_desc_en t_desc from test$ where pck_globs.lang = 1 union all
  select t_id, t_desc_de t_desc from test$ where pck_globs.lang = 2 union all
  select t_id, t_desc_pl t_desc from test$ where pck_globs.lang = 3;

I cannot create three row for three languages because of foregin key constraints.

Plese help me (even answering, that it's immpossible, so I wont think about it anymore).

Regards, Received on Sun Sep 28 1997 - 00:00:00 CDT