OraFAQ Forum: Forms » delete with where condition-in form

Home » Developer & Programmer » Forms » delete with where condition-in form

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

delete with where condition-in form [message #334979]

Sat, 19 July 2008 01:19

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;
-------------------------------------------------------

Report message to a moderator

Re: delete with where condition-in form [message #334986 is a reply to message #334979]

Sat, 19 July 2008 02:15

Frank
Messages: 7901
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?

Report message to a moderator

Re: delete with where condition-in form [message #334994 is a reply to message #334986]

Sat, 19 July 2008 02:56

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

Report message to a moderator

Re: delete with where condition-in form [message #334997 is a reply to message #334994]

Sat, 19 July 2008 03:16

Frank
Messages: 7901
Registered: March 2000

Senior Member

Don't you know how Forms works on blocks based on database tables?!
Better read your Forms-101 again.

Report message to a moderator

Re: delete with where condition-in form [message #334999 is a reply to message #334997]

Sat, 19 July 2008 03:41

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

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: delete with where condition-in form [message #335039 is a reply to message #334979]

Sat, 19 July 2008 21:57

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

Report message to a moderator

Previous Topic:	background color
Next Topic:	Retrive PDF in Acrobat Reader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 06:16:35 CST 2025