Home » Developer & Programmer » Forms » Chnage the value of the field (just for demo)
Chnage the value of the field (just for demo) [message #318103] Mon, 05 May 2008 10:59 Go to next message
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?
Re: Chnage the value of the field (just for demo) [message #318109 is a reply to message #318103] Mon, 05 May 2008 11:57 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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).
Re: Change the value of the field (just for demo) [message #318175 is a reply to message #318109] Tue, 06 May 2008 00:38 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: Change the value of the field (just for demo) [message #318241 is a reply to message #318176] Tue, 06 May 2008 03:38 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know how you did that, but - it works fine for me.

./fa/4242/0/
Re: Change the value of the field (just for demo) [message #318252 is a reply to message #318241] Tue, 06 May 2008 04:23 Go to previous message
mmrz
Messages: 29
Registered: August 2007
Junior Member
Thank you, I got it, I did some redicules mistaks but it is ok now.
Previous Topic: Inserting and deleting records
Next Topic: To change the datatype using format mask --
Goto Forum:
  


Current Time: Fri Dec 02 14:11:56 CST 2016

Total time taken to generate the page: 0.10052 seconds