Home » Developer & Programmer » Forms » Oracle Forms saving problem (Oracle forms 10g)
Oracle Forms saving problem [message #588884] Sat, 29 June 2013 07:18 Go to next message
tktoishi
Messages: 3
Registered: June 2013
Location: Dhaka,Bangladesh
Junior Member

I create a data block on a table when I am inserting new record only one record have been saved. Last record no longer exist.
  • Attachment: save.PNG
    (Size: 8.55KB, Downloaded 50 times)
Re: Oracle Forms saving problem [message #588915 is a reply to message #588884] Sat, 29 June 2013 14:03 Go to previous messageGo to next message
cookiemonster
Messages: 10961
Registered: September 2008
Location: Rainy Manchester
Senior Member
Run the form in debug mode and see what triggers fire
Re: Oracle Forms saving problem [message #588916 is a reply to message #588884] Sat, 29 June 2013 14:04 Go to previous messageGo to next message
Littlefoot
Messages: 19631
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is block's layout style? Form or tabular? Could you attach form's screenshot which shows records you entered? Mark a record that was saved (or the ones that were not).
Re: Oracle Forms saving problem [message #588942 is a reply to message #588916] Sun, 30 June 2013 06:53 Go to previous messageGo to next message
tktoishi
Messages: 3
Registered: June 2013
Location: Dhaka,Bangladesh
Junior Member

./fa/10947/0/
  • Attachment: saving.png
    (Size: 16.38KB, Downloaded 113 times)
Re: Oracle Forms saving problem [message #588950 is a reply to message #588942] Sun, 30 June 2013 16:17 Go to previous message
Littlefoot
Messages: 19631
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How exactly did you enter these two records? I guess you simply overtyped the first record's values. Here's what you should have done:
  • enter first record's values
  • create a new record (you'd do that by pressing the arrow DOWN key or by pushing the green PLUS button in Forms toolbar)
  • a new, empty record is displayed on the screen. If it was a tabular form layout, it would be more obvious; in a form layout, the first record you entered was (kind of) "moved up" and you don't see it any more
  • now, enter second record's values (the ones we see on the screenshot)
  • now, save changes (i.e. COMMIT

What is the result now?
Previous Topic: running .bat file
Next Topic: WHEN-NEW-FORM-Instance trigger
Goto Forum:
  


Current Time: Mon Sep 22 05:23:01 CDT 2014

Total time taken to generate the page: 0.06019 seconds