Home » Developer & Programmer » Forms » Simulating delete_record function (oracle 10g)
Simulating delete_record function [message #663526] Wed, 07 June 2017 03:31 Go to next message
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
Re: Simulating delete_record function [message #663529 is a reply to message #663526] Wed, 07 June 2017 04:20 Go to previous messageGo to next message
Littlefoot
Messages: 21691
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'
Re: Simulating delete_record function [message #663530 is a reply to message #663529] Wed, 07 June 2017 05:00 Go to previous messageGo to next message
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
Re: Simulating delete_record function [message #663531 is a reply to message #663529] Wed, 07 June 2017 05:42 Go to previous message
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)
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:
  


Current Time: Sun Dec 05 01:51:39 CST 2021