forms6i-urgent

[rao]

Hi

I have a control block where in i have placed two text items 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

[stecal]

Well, for one, if you are tyring to update the order table, what is the ":control.carrier" referring to? Certainly not a column in the order table.

For another, it is hard to tell where or what your problem is when not all of the code is present for others to read.

Lastly, consider using forms_ddl.

And double lastly, did you cut and paste the code you posted here? You are missing a semicolon at the end of v_order_id declaration.

[rao]

Originally posted by stecal
Well, for one, if you are tyring to update the order table, what is the ":control.carrier" referring to? Certainly not a column in the order table.

For another, it is hard to tell where or what your problem is when not all of the code is present for others to read.

Lastly, consider using forms_ddl.

And double lastly, did you cut and paste the code you posted here? You are missing a semicolon at the end of v_order_id declaration.

what my problem is,control.carrier is a non-databsase item,when i enter data there the actual database should get updated as an when i enter data in the carrier.i.e carrier should go and sit in the actual database column that is the user_class1;when i say

update orders set :control.carrier = v_user_class1 where
order_id = v_order_id;
the control.carrier should go and sit in the actual database table and update for the id.
It is giving me an error at :control.carrier Encounterd the symbol when expecting the following at line 10 column11 with ""
please help me i have to show it tommorrow

[Edited by rao on 10-20-2002 at 04:16 PM]

[stecal]

Maybe I'm clueless as to what :control.carrier is supposed to do, BUT I do know that when you are issuing a DML statement (update, in this case), Oracle is expecting a column name for the table you are referencing, not some contrived data-like placeholder (:control.carrier).

[rao]

Originally posted by stecal
Maybe I'm clueless as to what :control.carrier is supposed to do, BUT I do know that when you are issuing a DML statement (update, in this case), Oracle is expecting a column name for the table you are referencing, not some contrived data-like placeholder (:control.carrier).

Is there any method to update a database via control block to the actual database.i.e when i enter a value in an item in the control block that value has to go and sit in the database and updated in the database.please help me