a statement [message #590] |
Fri, 22 February 2002 13:49 |
JOHN
Messages: 182 Registered: April 1998
|
Senior Member |
|
|
i have a problem with a p/sql statement. i have a text box (excess) that acts gets it data from another text box on the trigger post-change-item. i would like the statement to get data from two other boxes mess,excess. (these text boxes have been created by me and not the wizard) and then proform a check and produce action according to that check.
the following is the code i am having trouble with. it excutes all right however i do not believe it is syntaxally correct.
declare
v_allow Rental.allow%type;
begin
v_allow:=(:mess*:allow);
if v_allow<:MILES then
:excess:=(v_allow-:miles);
end if;
end;
|
|
|
|