OraFAQ Forum: Forms » How to save formula item in table

Home » Developer & Programmer » Forms » How to save formula item in table

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

How to save formula item in table [message #168210]

Wed, 19 April 2006 05:28

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

i want to save formula item in table

i created a table

kgs1 number (6)
kgs2 number (6)

on the form i create a block in this block I also add 2 item temp1 (no database) & temp2 (no database) with KGS1 & kgs2

now i write formula in temp1 & temp2 both are formula items.

Calclation mode is formula.

now I want that temp1 save as kgs1 and temp2 as kgs2.

Kamran

Report message to a moderator

Re: How to save formula item in table [message #168218 is a reply to message #168210]

Wed, 19 April 2006 05:49

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please give an example of a 'formula item'. Is this an assignment or just a mental exercise? If the prior please key the specification into your reply.

David

Report message to a moderator

Re: How to save formula item in table [message #168236 is a reply to message #168218]

Wed, 19 April 2006 06:54

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

Create table temp
kgs1 number(1),
kgs2 number(2));

2.
create a form and block temp
in this block are 4 items KGS1,KGS2 and TEMP1,TEMP2 not a database item.

3. changed property of TEMP1
Calculation mode = Formula
formula = :temp1*temp2

temp1 and temp2 can not save in table

now how I save KGS1 as temp1

Report message to a moderator

Re: How to save formula item in table [message #168276 is a reply to message #168236]

Wed, 19 April 2006 09:26

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Kamran,

Please discuss this problem with a colleague and get them to help you with explaining what you are trying to do. Both your entries are very similar and are not giving me any useful idea of what you are trying to do.

David

Report message to a moderator

Re: How to save formula item in table [message #168400 is a reply to message #168276]

Thu, 20 April 2006 04:06

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

It is done
write pre-update trigger in desire block

begin
:pp_kd2.dkgs1:=:pp_kd2.dtmp1;
:pp_kd2.dkgs2:=:pp_kd2.dtmp2;
:pp_kd2.ckgs:=:pp_kd2.ctmp1;
:pp_kd2.ckgs2:=:pp_kd2.ctmp2;
end;

Report message to a moderator

Previous Topic:	i cannot rollback
Next Topic:	How to set the font size when using the HOST command from Form?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 10:48:12 CST 2025