Home » SQL & PL/SQL » SQL & PL/SQL » a statement
a statement [message #590] Fri, 22 February 2002 13:49 Go to next message
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;
Re: a statement [message #610 is a reply to message #590] Mon, 25 February 2002 00:27 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
use :block_name.item_name instead of :item_name. otherwise ur code is fine
Previous Topic: how to handle
Next Topic: How can I find the last_updated row in a table?
Goto Forum:
  


Current Time: Fri Sep 17 02:39:09 CDT 2021