OraFAQ Forum: Forms » if condition in post-change

Home » Developer & Programmer » Forms » if condition in post-change (10gR2, windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

if condition in post-change [message #575420]

Wed, 23 January 2013 02:06

7anona
Messages: 72
Registered: February 2012

Member

hello all..
I have a view t1
having the records:
1 A
1 A+
2 B
3 C
4 D

I want to display that in an LOV
but without the first record (1 A)
I used the code :

Code: [Select all] [Show/ hide]

SELECT DISTINCT num, 
DECODE(num,1,(SELECT DISTINCT desc FROM t1 a
WHERE a.desc='A+'AND a.num=1),desc) desc
FROM t1

this worked fine but
how to apply this in a post_change trigger where
a user inters the num and the desc appears in atext-item
in my form

I will appreciate any assistance
thanks in advance

Report message to a moderator

Re: if condition in post-change [message #575425 is a reply to message #575420]

Wed, 23 January 2013 03:29

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Wrong trigger; you should switch to WHEN-VALIDATE-ITEM (when inserting values) and POST-QUERY (when querying them). POST-CHANGE is here for backward compatibility - don't use it.

As of your question, regarding sample data you provided:

Code: [Select all] [Show/ hide]

select max(t.description)
  into :block.description
  from your_table t
  where t.id = :block.id;

The same (MAX) goes for a LoV query.

Report message to a moderator

Previous Topic:	sql loader with Oracle forms 10g
Next Topic:	WHEN MOUSE DOUBLE CLICK is not fired

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 03 06:47:25 CDT 2025