OraFAQ Forum: Forms » updating data into table through non-database column in a form

Home » Developer & Programmer » Forms » updating data into table through non-database column in a form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

updating data into table through non-database column in a form [message #601753]

Mon, 25 November 2013 05:38

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

Hi,

In a block I have 7 column, among 7 column 5 are database column and other 2 are non database column.
suppose 5 column belong to EMP table and other 2 column belong to STU table.
both the table are linked through emp_id.
I am not supposed to create a view so i have created the 5 column based on EMP table and other 2 column is non-database column.
through POST_QUERY trigger i am displaying the value in the 2 column of STU table.

When I am updating the 2 column of STU table alone through form it is not updating.
But when I am updating the 2 column of STU table along the 5 column of EMP table it is getting update.

Please help me with the solution so that i can update only the 2 STU column.

Thanks

Report message to a moderator

Re: updating data into table through non-database column in a form [message #601754 is a reply to message #601753]

Mon, 25 November 2013 05:44

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

How is stu getting updated if the emp columns are changed?

Report message to a moderator

Re: updating data into table through non-database column in a form [message #601755 is a reply to message #601754]

Mon, 25 November 2013 05:46

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

I have used a trigger ON-UPDATE trigger and calling a procedure through this trigger.
Inside pocedure i have written a update command to update the both the table.

Report message to a moderator

Re: updating data into table through non-database column in a form [message #601761 is a reply to message #601755]

Mon, 25 November 2013 06:21

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

You could trick forms into thinking one of emp columns has changed, something like this in the when-validate-item on the stu items:

DECLARE

l_cur_val emp.<item>%type := :emp.<item>;

BEGIN

:emp.<item> := '????????';
:emp.<item> := l_cur_val;

END;

You'll need to pick an item without any validation triggers of it's own.

Alternatively:
1) base the block on a view
2) base the block on a stored procedure

Report message to a moderator