Home » Developer & Programmer » Forms » forms6i-urgent
forms6i-urgent [message #80603] Sat, 19 October 2002 12:28 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Forms6i-urgent
Next Topic: Forms9i Urgent
Goto Forum:
  


Current Time: Thu Mar 28 16:15:48 CDT 2024