Home » Developer & Programmer » Forms » How I can change the value of item to decode value?
How I can change the value of item to decode value? [message #83635] Wed, 12 November 2003 07:13 Go to next message
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
Re: How I can change the value of item to decode value? [message #83639 is a reply to message #83635] Fri, 14 November 2003 01:40 Go to previous messageGo to next message
Maaher
Messages: 7064
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
Re: How I can change the value of item to decode value? [message #83644 is a reply to message #83635] Sun, 16 November 2003 08:11 Go to previous message
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 Aug 13 01:08:41 CDT 2022