OraFAQ Forum: Forms » Chnage the value of the field (just for demo)

Home » Developer & Programmer » Forms » Chnage the value of the field (just for demo)

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

Chnage the value of the field (just for demo) [message #318103]

Mon, 05 May 2008 10:59

mmrz
Messages: 29
Registered: August 2007

Junior Member

I use oracle form6i , I retreive the data of one field from database, so there are several rows related to that field which shows on the form, I wanna get one by one of the field value and do some process on it and change the values and just show the new value on the form without effecting on the real value on database, what should I do?

Report message to a moderator

Re: Chnage the value of the field (just for demo) [message #318109 is a reply to message #318103]

Mon, 05 May 2008 11:57

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

Senior Member
Account Moderator

This database item should be invisible. Create and display another, non-database item which will be populated in POST-QUERY trigger (depending on calculations you want to apply to the original value).

Report message to a moderator

Re: Change the value of the field (just for demo) [message #318175 is a reply to message #318109]

Tue, 06 May 2008 00:38

mmrz
Messages: 29
Registered: August 2007

Junior Member

I create a new Item(Item01) and use this following code:
:ITEM01 := :x.y;
:x.y has the value(just the first row value) but no data will appear at ITEM01.
How can I get all row's values and put it in the ITEM01 which is non db item.(by code)

[EDITED by LF: disabled smilies in this message]

[Updated on: Tue, 06 May 2008 03:28] by Moderator

Report message to a moderator

Re: Change the value of the field (just for demo) [message #318176 is a reply to message #318175]

Tue, 06 May 2008 00:40

mmrz
Messages: 29
Registered: August 2007

Junior Member

sorry I use one letter on my previous message but I do not know why it shows like x, so let me explain it by the another letter:
:S.y which is the the one filed that retrieve from db.

Report message to a moderator