problem with trigger [message #176725] |
Fri, 09 June 2006 05:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Catty
Messages: 64 Registered: April 2006 Location: Poland
|
Member |
|
|
Hello!
I have form with some fields. One of those fields names AKTUALNY_ZAKLAD. I want make such thing:
When I insert fields, this AKTUALNY_ZAKLAD should be insert-able, changeable etc. But if I enter query ( using F7 key) and accept that query ( using F8 key) AKTUALNY_ZAKLAD should be lock, and user should not have possible to change it.
For this filed I have triggers:
WHEN-NEW-ITEM-INSTANCE
begin
if :au1.aktualny_zaklad is null
then do_key('list_values');
end if;
end;
POST-TEXT_ITEM
set_item_property(:SYSTEM.CURRENT_BLOCK||'.'||:SYSTEM.CURRENT_ITEM,BORDER_BEVEL,PLAIN);
--RAISED,LOWERED,PLAIN
and PRE-TEXT-ITEM
set_item_property(:SYSTEM.CURRENT_BLOCK||'.'||:SYSTEM.CURRENT_ITEM,BORDER_BEVEL,PLAIN);
--RAISED,LOWERED,PLAIN
for my needs, I have made trigger
KEY-F7
set_item_property(:au1.aktualny_zaklad,insert_allowed,property_false);
but it doesn't work please help
|
|
|
|
Re: problem with trigger [message #176912 is a reply to message #176745] |
Mon, 12 June 2006 00:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Catty
Messages: 64 Registered: April 2006 Location: Poland
|
Member |
|
|
I have made trigger:
KEY-F7 on item level:
set_item_property(AU1:.AKTUALNY_ZAKLAD,query_allowed,property_false);
but it is still wrong:-(
Please help.
|
|
|
|
|
|
|
|