OraFAQ Forum: Forms » Deleting records from block

Home » Developer & Programmer » Forms » Deleting records from block (forms6i)

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

Deleting records from block [message #518216]

Tue, 02 August 2011 03:48

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

hi,

I want to delete records from block in the form.could you please explain where(in which trigger) should i write set_block_property.

[EDITED by LF: fixed topic title typo; was "delitting"]

[Updated on: Tue, 02 August 2011 04:04] by Moderator

Report message to a moderator

Re: Delitting records from block [message #518217 is a reply to message #518216]

Tue, 02 August 2011 03:50

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

What's set_block_property got to do with it?
What property were you planning on setting?

Report message to a moderator

Re: Delitting records from block [message #518218 is a reply to message #518217]

Tue, 02 August 2011 03:55

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

When i press delete button record should be delete from database?could you please explain this?

Report message to a moderator

Re: Delitting records from block [message #518219 is a reply to message #518217]

Tue, 02 August 2011 03:57

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

Senior Member
Account Moderator

If it is a database block, and records are fetched from a database, go to the record you want to delete, and push the "Delete" button on the toolbar. Then push the "Save" button to commit changes.

/forum/fa/9235/0/

Attachment: toolbar.png
(Size: 7.52KB, Downloaded 1303 times)

Report message to a moderator

Re: Deleting records from block [message #518243 is a reply to message #518216]

Tue, 02 August 2011 07:55

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

when-button-pressed

delete_record;

QED.

Report message to a moderator

Re: Deleting records from block [message #518263 is a reply to message #518243]

Tue, 02 August 2011 11:12

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

Senior Member
Account Moderator

Right; but, why creating a button that already exists in the toolbar?

Report message to a moderator

Re: Deleting records from block [message #518385 is a reply to message #518263]

Wed, 03 August 2011 08:20

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Littlefoot wrote on Tue, 02 August 2011 12:12

Right; but, why creating a button that already exists in the toolbar?

Yes, but maybe he (although I doubt it based on the quality of questions he asks) has overridden the default menu module.

Report message to a moderator

Re: Deleting records from block [message #518390 is a reply to message #518385]

Wed, 03 August 2011 08:24

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Someone may have overridden it for him.

Report message to a moderator

Re: Delitting records from block [message #519215 is a reply to message #518219]

Wed, 10 August 2011 07:07

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

If it is not database block then how can i delete with "Delete" button on the toolbar.Incase some fields from database block and some fields from Non-database then?

Report message to a moderator

Re: Delitting records from block [message #519227 is a reply to message #519215]

Wed, 10 August 2011 08:05

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

If it's not a database block then you'll need to write a delete statement in the when-button-pressed trigger.

rajendaroracle wrote on Wed, 10 August 2011 13:07

Incase some fields from database block and some fields from Non-database then?

Depends on what exactly you want to be deleted.

Report message to a moderator

Previous Topic:	RUN_REPORT_OBJECT (merged 2)
Next Topic:	Displaying database stored image on Oracle Forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 10:03:06 CST 2025