OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » Flag Set

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

Flag Set [message #269685]

Mon, 24 September 2007 01:52

nayana
Messages: 33
Registered: August 2007
Location: Bangalore

Member

Hi,

Created one table and it contains following columns:
empno, name , mailid,DOJ,location etc.

and also created one form to enter these columns data. Form contains add/delete/update buttons.

When i select delete button it will delete entire row from the table. But I want data in case any employee rejoined. I heard that its possible using flag set, but i don't know the commands for that. Please advice.

Thanks in advance.

Regards,
Nayana

Report message to a moderator

Re: Flag Set [message #269687 is a reply to message #269685]

Mon, 24 September 2007 02:01

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Flag Set is nothing but up to you.

Report message to a moderator

Re: Flag Set [message #269695 is a reply to message #269687]

Mon, 24 September 2007 02:24

nayana
Messages: 33
Registered: August 2007
Location: Bangalore

Member

Hi,

Could please explain me with examples.

Thanks,
Nayana

Report message to a moderator

Re: Flag Set [message #269698 is a reply to message #269695]

Mon, 24 September 2007 02:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Add a field to the table called 'deleted_fl'. Then write an 'on-delete' trigger which will intercept the 'delete' command and update the row so that the flag is set to 'Y' (or something).

Chaneg the 'default_where' so that it contains something like "nvl(deleted_fl,'N') <> 'Y'". This way your 'deleted' entries will not be displayed.

David

Report message to a moderator

Re: Flag Set [message #269739 is a reply to message #269698]

Mon, 24 September 2007 06:37

nayana
Messages: 33
Registered: August 2007
Location: Bangalore

Member

Hi,

Thanks a Lot!

Used following code.

create or replace trigger "EMP_DAYS_T1"
AFTER
delete on "EMP_DAYS"
begin
update emp_days set deleted_fl='Y' where empno=206;
end;

But this trigger is only for one employee (i.e 206).So I used :

create or replace trigger "EMP_DAYS_T1"
AFTER
delete on "EMP_DAYS"
begin
update emp_days set deleted_fl='Y' where empno=:new.empno;
end;

But the above code gives Error:

ORA-04082: NEW or OLD references not allowed in table level triggers

Could you please let me know why?

Regards,
Nayana

Report message to a moderator

Re: Flag Set [message #269751 is a reply to message #269739]

Mon, 24 September 2007 07:20

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

You should try this in a row level trigger.

By
Vamsi

Report message to a moderator

Re: Flag Set [message #269759 is a reply to message #269751]

Mon, 24 September 2007 07:44

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

... and suffer from the mutating table error.

David told you to use the ON-DELETE trigger - it is a form trigger, not database trigger!

Report message to a moderator

Re: Flag Set [message #269760 is a reply to message #269751]

Mon, 24 September 2007 07:51

nayana
Messages: 33
Registered: August 2007
Location: Bangalore

Member

Hi,

Thanks a Lot Vamsi.

Its working!!!

Regards,
Nayana

Report message to a moderator

Re: Flag Set [message #269761 is a reply to message #269759]

Mon, 24 September 2007 07:53

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Oops!! today is a bad day for me.
Many overlooks. Mad

Didn't notice the table name is same as the table, on which the DML has written.

By
Vamsi

Report message to a moderator

Re: Flag Set [message #269762 is a reply to message #269760]

Mon, 24 September 2007 07:55

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Quote:

Its working!!!

Really?
Did you compile the trigger? (or) Isn't it giving run time errors?

By
Vamsi

Report message to a moderator

Re: Flag Set [message #269765 is a reply to message #269762]

Mon, 24 September 2007 08:01

nayana
Messages: 33
Registered: August 2007
Location: Bangalore

Member

Hi Vamsi,

Oh!!

 successfully compiled

.

But when I tried to delete the record no flag set.

Razz

Nayana

Report message to a moderator

Re: Flag Set [message #269828 is a reply to message #269765]

Mon, 24 September 2007 15:15

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So, what did you, actually, do? Which trigger did you create? How does it look like?

If it was a database trigger, form will compile successfully as it didn't do anything with the trigger (yet). It would fail during runtime.

If it was a form trigger, what did you put in it so that it doesn't work? How do you know it doesn't work? Did you COMMIT changes you've made in order to make those changes permanent (including setting the flag)?

Report message to a moderator

Re: Flag Set [message #269849 is a reply to message #269828]

Mon, 24 September 2007 19:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

As part of the 'delete' processing cycle the form will have done a 'commit'. So you need to make sure that the database trigger has been removed and that your form logic is flowing as you have anticipated.

David

Report message to a moderator

Re: Flag Set [message #270449 is a reply to message #269849]

Wed, 26 September 2007 22:35

nayana
Messages: 33
Registered: August 2007
Location: Bangalore

Member

Thanks a Lot!

Razz

Nayana

Report message to a moderator

Previous Topic:	problem with a running form
Next Topic:	how to change text, on top of the forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 14:06:57 CDT 2025