max of 2 text items [message #87064] |
Fri, 03 December 2004 01:02 |
hudo
Messages: 165 Registered: May 2004
|
Senior Member |
|
|
Hello,
I have 2 text item TEXT_ALPHA and TEXT_BETA in a form, and would like to enter
in text item TEXT_GAMMA the maximum of the values of TEXT_ALPHA AND TEXT_BETA
How can this be done ?
|
|
|
Re: max of 2 text items [message #87065 is a reply to message #87064] |
Fri, 03 December 2004 01:50 |
Ani
Messages: 56 Registered: November 2000
|
Member |
|
|
Hi,
say u enter 10 in text_alpha
and 20 in text_beta, u want 20 to b displayed in text_gamma right??
if this s the case then in when validate of text_beta give a condition that
if :text_beta > :text_alpha then
:text_gamma:=:text_beta;
else
:text_gamma:=:text_alpha;
end if;
hope i have got it right.
pls reply back so that if i am wrong then i can correct myself.
all the best.
Ani
|
|
|
Re: max of 2 text items [message #87069 is a reply to message #87065] |
Fri, 03 December 2004 04:02 |
hudo
Messages: 165 Registered: May 2004
|
Senior Member |
|
|
Sorry if I misunderstood you, you mean a WHEN-VALIDATE-ITEM Trigger at Text_Beta ?
This works not. I also tried a POST-TEXT-ITEM Trigger, but this works only if I move/click into the field with the POST-TEXT-ITEM Trigger (text_beta) and then into text_gamma.
Let me explain the scenario:
I got a table displayed, the query is based on a stored procedure. There are some text_item with sum(column a) or (sum(column b))/(number of rows) and there is text_gamma with the told problem...
Greetings
|
|
|