I have two tables:
The problem is that if I enter the FEU for FilOprHyp and try to change it to edit mode (ED) I get the message "Edit mode is not allowed. This file may only be Browsed."
Is there some way of avoiding this? That is: some way of having constraints but still make it possible to edit with the FEU?
(I tried with "on update no action", but I got errors regarding journaling)
Code:
Exec SQL create table FilOprHyp ( Id numeric(3 , 0) not null, Tekst char(45) not null, Constraint unikt_id Primary key (Id) ); Exec SQL create table FilOpryd ( Fil char(10) not null, OprydHyp numeric(3 , 0) default 0, SqlQuery char(256), SidstKoert timestamp not null default timestamp('0001-01-01 00:00:00'), StatusKode numeric (5 , 0) not null default 0, Constraint unik_fil Primary key (Fil), Constraint opryd_hyppighed Foreign key (OprydHyp) References FilOprHyp (Id) on delete set default on update restrict );
Is there some way of avoiding this? That is: some way of having constraints but still make it possible to edit with the FEU?
(I tried with "on update no action", but I got errors regarding journaling)
Comment