Home » Developer & Programmer » Forms » about commit (oracle forms and reports 10g)
icon14.gif  about commit [message #441609] Tue, 02 February 2010 02:41 Go to next message
divya5468
Messages: 5
Registered: June 2009
Location: Chennai
Junior Member
there are so many forms in a single data block. i have placed a push button in the last form in a data block with this code:

commit;

this code inserts all the values of previous data blocks also.

My doubt is:

1)how to insert particular data block values using commit code?

2)there is a data block in tabular type with three rows. i want to insert all three rows at a time?

please help me....Thanks a lot........

[Updated on: Tue, 02 February 2010 02:47]

Report message to a moderator

Re: about commit [message #441615 is a reply to message #441609] Tue, 02 February 2010 03:34 Go to previous message
Littlefoot
Messages: 20825
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
  1. You can not - COMMIT commits the whole transaction (i.e. changes you've made in all of your blocks). It is not possible to choose which block to commit, and which not.
  2. What does it mean, "insert 3 rows at a time"? Commit? If so, a single commit will commit all three rows. If it is about populating items with values, you can't do that "at once", but record-by-record. If none of the above, what then?
Previous Topic: HELP ME (merged)
Next Topic: Problem with dbms_sql and LIKE clause
Goto Forum:
  


Current Time: Mon Sep 26 16:18:46 CDT 2016

Total time taken to generate the page: 0.21627 seconds