OraFAQ Forum: Forms » Decode Function (merged)

Home » Developer & Programmer » Forms » Decode Function (merged) (Oracle 10g Forms)

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

Decode Function (merged) [message #475601]

Thu, 16 September 2010 01:40

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

HI fRIENDS,
I have Two cursor reord block..which is attached in form..
My TASK IS
In my first Block, When DBCR Column = 'D' Then in backend this column value should be save as a '1'
WHEN DBCR Column = 'C' Then Then in backend this column value should be save as a '2'

My Both Field is on Data Block...

I dont hv any idea how to solve this problem..

In Property palette of this field can we write any decode condition..so it reflects directly on database..

Please check my attached form

Attachment: Adv_adj.fmb
(Size: 340.00KB, Downloaded 1009 times)

Report message to a moderator

Re: Decode Function [message #475606 is a reply to message #475601]

Thu, 16 September 2010 01:54

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

who cares about the back end? Why you care much of what to be stored in the database?

If you still want that, then put some codes on pre-insert, pre-update and the likes.

ALSO, don't create multiple thread for this single problem.

[Updated on: Thu, 16 September 2010 01:55]

Report message to a moderator

Re: Decode Function [message #475623 is a reply to message #475606]

Thu, 16 September 2010 03:46

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Well list items display one value and store another.
If you don't want to use them then I suggest you:
1) Remove the item from the canvas.
2) Replace it with a non-database item
3) Add a when-validate-item trigger to the non-database item that'll put the correct value in the database item.
4) Add a post-query trigger to populate the non-database item.

Report message to a moderator

Previous Topic:	Non-Equi Join In Oracle Forms
Next Topic:	Issues in alignment of labels (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 13:07:47 CDT 2024