OraFAQ Forum: Forms » Simulating delete

Home » Developer & Programmer » Forms » Simulating delete_record function (oracle 10g)

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

Simulating delete_record function [message #663526]

Wed, 07 June 2017 03:31

Hatik
Messages: 12
Registered: June 2017

Junior Member

I am trying to simulate delete_record function, in my system on button press trigger from 'delete_button' it sets the status of the row to be 'D'(Deleted'), Now I would like to add some functionality to that trigger, so that after the button is pressed it would disappear from the table just like if I use delete_record; function, but I don't want the record to be deleted from table, is it possible to achieve?
P.S data is filled manually and by query

Report message to a moderator

Re: Simulating delete_record function [message #663529 is a reply to message #663526]

Wed, 07 June 2017 04:20

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

Senior Member
Account Moderator

The simplest option seems to be setting data block's WHERE clause; something like

where status <> 'D'

Report message to a moderator

Re: Simulating delete_record function [message #663530 is a reply to message #663529]

Wed, 07 June 2017 05:00

Hatik
Messages: 12
Registered: June 2017

Junior Member

so I will need to re execute_query then, no? because the status changed during run time

Report message to a moderator

Re: Simulating delete_record function [message #663531 is a reply to message #663529]

Wed, 07 June 2017 05:42

Hatik
Messages: 12
Registered: June 2017

Junior Member

the only other solution that I was able to come up with is to, not exactly deleting the row from table, but disabling from updating it and assigning visual attribute similar to disabled(grey color)

Report message to a moderator

Previous Topic:	FRM-40734 Internal Error PL/SQL error occurred with forms 11grt2 webutil
Next Topic:	form-40202 when focus on new field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:57:52 CST 2024