Home » Developer & Programmer » Forms » commit
commit [message #232773] Mon, 23 April 2007 04:22 Go to next message
imen_mr2004
Messages: 22
Registered: October 2006
Location: tunisia
Junior Member
my problem consists on commit instructions. In fact, when i bring informations by query an whant to update table, the form disappears, just like if there was a problem , this problem exists only when i want to update, i tryed whith "commit" and "commit_form" but no results, what can i do? pleaaaaase help me. Thanks.
Re: commit [message #232806 is a reply to message #232773] Mon, 23 April 2007 06:02 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
imen_mr2004 wrote on Mon, 23 April 2007 14:22
when i bring informations by query an whant to update table, the form disappears, just like if there was a problem



Try to rebuild you form I think there is a problem in your form.
Re: commit [message #232893 is a reply to message #232806] Mon, 23 April 2007 19:12 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If you are doing a manual 'update' then you need to do a manual 'commit'. In Oracle Forms a manual commit is done by 'standard.commit'.

Unless you are updating a table not referenced by a block in your form you should not need to do a manual update.

David
Re: commit [message #232941 is a reply to message #232893] Tue, 24 April 2007 03:21 Go to previous messageGo to next message
imen_mr2004
Messages: 22
Registered: October 2006
Location: tunisia
Junior Member
thanks for answering but i'm updating table via a block, so i need a commit; if not what shall i do to save changes.
thanks
Re: commit [message #236419 is a reply to message #232941] Wed, 09 May 2007 23:45 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What do you mean by "i'm updating table via a block"? A block will do inserts, updates, and deltes automatically for you. You don't need to manipulate the data directly.

David
Previous Topic: how can pass a parameter to function at run time in oracle 10g developer
Next Topic: HELP: to pass parameters between forms in forms personalization
Goto Forum:
  


Current Time: Fri Dec 09 06:06:05 CST 2016

Total time taken to generate the page: 0.23977 seconds