Home » Developer & Programmer » Forms » delete with where condition-in form
icon12.gif  delete with where condition-in form [message #334979] Sat, 19 July 2008 01:19 Go to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Dear Sir,
How can i write delete statement in oracle form a when button pressed trigger.
that is...
------------------------------------------------------
delete from HM_SHIFT_DAY where SHIFT_MONTH=:text01;
-------------------------------------------------------

Re: delete with where condition-in form [message #334986 is a reply to message #334979] Sat, 19 July 2008 02:15 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Forms has built-in functionality for this. Why do you want to override?

What happened when you tried your suggested statement?
Re: delete with where condition-in form [message #334994 is a reply to message #334986] Sat, 19 July 2008 02:56 Go to previous messageGo to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Dear Frank
thanks for your replay,
pls provide me which built in function we can user like this
operation. how can i use it and give me a simple example.


regards



Re: delete with where condition-in form [message #334997 is a reply to message #334994] Sat, 19 July 2008 03:16 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Don't you know how Forms works on blocks based on database tables?!
Better read your Forms-101 again.
icon11.gif  Re: delete with where condition-in form [message #334999 is a reply to message #334997] Sat, 19 July 2008 03:41 Go to previous messageGo to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Frank wrote on Sat, 19 July 2008 14:16
Don't you know how Forms works on blocks based on database tables?!
Better read your Forms-101 again.

Sorry Sir,
I have some confusion about u.... Shocked

[Updated on: Sat, 19 July 2008 03:46]

Report message to a moderator

Re: delete with where condition-in form [message #335029 is a reply to message #334999] Sat, 19 July 2008 11:46 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe that Frank is trying to suggest you to use built-in Forms toolbar; among other buttons, there's also the DELETE RECORD button (a red x, possibly) which will do exactly what you are trying to do in the WHEN-BUTTON-PRESSED trigger - delete a record.

So, why would you want to reinvent the wheel?
icon9.gif  Re: delete with where condition-in form [message #335039 is a reply to message #334979] Sat, 19 July 2008 21:57 Go to previous message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Thanks to all
i had done.im sorry coz i had not understood Frank's Ans. Sad
Previous Topic: background color
Next Topic: Retrive PDF in Acrobat Reader
Goto Forum:
  


Current Time: Sun Dec 04 13:05:39 CST 2016

Total time taken to generate the page: 0.10124 seconds