OraFAQ Forum: Forms » forms save button

Home » Developer & Programmer » Forms » forms save button (form 10g)

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

forms save button [message #462222]

Wed, 23 June 2010 04:17

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

I have created one non database block and one database block
from non database block i am taking input
on these input i am getting output in database block

output coming correctly
now if i press ctrl+s it save data correctly

now i want a push button for saving the same data
is that i need to write all code again on when-button-pressed...? or is their any method to call for save data..?

Report message to a moderator

Re: forms save button [message #462227 is a reply to message #462222]

Wed, 23 June 2010 04:29

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

Senior Member

Why not just use the toolbar button that already exists for this purpose?
commit_form should be all you need.

Report message to a moderator

Re: forms save button [message #462228 is a reply to message #462227]

Wed, 23 June 2010 04:32

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

user need the push button only that why i get confuse ...otherway my form is saving all data well....

i just want that save all that dat by click on command button...same thing as toolbar button do....

for that what should i write on when-button-pressed trigger..?

Report message to a moderator

Re: forms save button [message #462230 is a reply to message #462227]

Wed, 23 June 2010 04:40

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

Senior Member

cookiemonster wrote on Wed, 23 June 2010 10:29

commit_form should be all you need.

Report message to a moderator

Re: forms save button [message #462236 is a reply to message #462230]

Wed, 23 June 2010 04:48

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

thanks...i try that now....

but after that i written clear_block.....
for next record insertion.....
but it showing no-data found error..
and when i close window it again asking me for save changes or not...?

Report message to a moderator

Re: forms save button [message #462240 is a reply to message #462236]

Wed, 23 June 2010 04:57

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

Senior Member

Why have you written clear_block?
what is showing no_data_found?

Report message to a moderator

Re: forms save button [message #462242 is a reply to message #462240]

Wed, 23 June 2010 05:01

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

after save button pressed i want clear the all fields for new record searching and inserting thats why i want clear block....but it not work..if i put clear_block then it showing no-data-found error
if i remove clear_block data saving well
but when i close my form window it again asking me for save changes

Report message to a moderator

Re: forms save button [message #462251 is a reply to message #462242]

Wed, 23 June 2010 05:15

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

Senior Member

Clear_block can not cause a no_data_found error - so there must be some other code that is firing that is causing it. You need to find what it is.
If the data is saving and then it asks if you want to save changes that means that some other changes have happened to the data block that oracle thinks need applying to the database. But since I have no idea how you've coded your form I couldn't begin to guess what you've done to cause this.

Report message to a moderator

Re: forms save button [message #462252 is a reply to message #462242]

Wed, 23 June 2010 05:16

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

after click on save button just i want form get load and look same as 1st time form opened

and while close window dont prompt save changes window..?

Report message to a moderator

Re: forms save button [message #462257 is a reply to message #462252]

Wed, 23 June 2010 05:28

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

Senior Member

I gathered that.

You have coded something that prevents both of these things from happening.
What - I have no idea.

Report message to a moderator

Re: forms save button [message #462348 is a reply to message #462242]

Wed, 23 June 2010 11:29

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

Senior Member
Account Moderator

lokeshsurana wrote on Wed, 23 June 2010 12:01

after save button pressed i want clear the all fields for new record searching and inserting

Wouldn't that be, perhaps, ENTER_QUERY instead of CLEAR_BLOCK?

Report message to a moderator

Re: forms save button [message #462349 is a reply to message #462348]

Wed, 23 June 2010 11:35

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

Senior Member

I'm assuming it's the same form as this thread.
In which case no, but it might well solve a lot of issues if the form was changed to use default query behavoiur.

Report message to a moderator

Previous Topic:	How to invoke dll from Oracle Forms 10g
Next Topic:	Help,help.Oracle Form auto exit if no user operat.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:44:43 CDT 2024