| forms6i-urgent [message #80603] |
Sat, 19 October 2002 12:28  |
muralidhar
Messages: 13
Registered: September 2002
|
Junior Member |
|
|
Hi
I have a control block where in i have placed two text items carrier&ticket and a save button.When i enter data into those two text items the actual database shoud be updated when i press the save button.My update
statement is like this
declare
v_user_class1 order.user_class%type;
v_order_id order.order_id%type
begin
update order set :control.carrier = v_user_class1 where
order_id = v_order_id;
end;
It gives me an error saying
Encountered the symbol " " when expecting one of following
at line 10.
please help me out.I have to show it tommortrow.
It will be a great help
|
|
|
|
| Re: forms6i-urgent [message #80605 is a reply to message #80603] |
Sun, 20 October 2002 00:36  |
Remash
Messages: 52
Registered: November 2000
|
Member |
|
|
Hi
In your update statement replace the ':control.carrier' with the actual field name in the table. Before the update statement you have to assign values to the variables 'v_user_class1' and 'v_order_id'
Regards
|
|
|
|
| Re: forms6i-urgent [message #80617 is a reply to message #80603] |
Mon, 21 October 2002 08:48 |
Julie
Messages: 98
Registered: February 2002
|
Member |
|
|
It wants the semicolon after your 2nd variable declaration.
And then in your update statement use the table column name, not the :block.item name.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
