OraFAQ Forum: Forms » How I can change the value of item to decode value?

Home » Developer & Programmer » Forms » How I can change the value of item to decode value?

Wed, 12 November 2003 07:13

Danny
Messages: 11
Registered: June 2001

Junior Member

I have a block detail not updatable type table and I have a value of item that i want change like decode function. How can I do?

Thanks

Fri, 14 November 2003 01:40

Maaher
Messages: 7065
Registered: December 2001

Senior Member

In the post-query of the block:

Select your_decode_function 
  Into Your_Item
  From dual;

If it is non-updatable, use non-database item.

MHE

Sun, 16 November 2003 08:11

Zain
Messages: 30
Registered: October 2003

Member

If detail block is populated by a query, write a post query trigger on detail block to change values.

Previous Topic:	nonversional repostory & service
Next Topic:	Field Increment

Goto Forum:

]

Current Time: Sat Nov 22 11:14:00 CST 2025