This content has been marked as final. Show 5 replies
Commit processing in Forms is an all or nothing process. You cannot pick and choose which records will be commited during a Commit_Form or Commit call. Based on your description, I don't see why you would need to use the checkbox to keep track of which records are new since you state that you add the records through a cursor and then to save them. Forms already keeps track of which records were queried into a block and which records are new so a simple call to Commit_Form will accomplish what you want without the need to manually keep track of which records are new.
Hope this helps,
If a response is helpful or correct, please mark it accordingly.
With respects to my previous post, I have recently learned that you can actually perform the kind of COMMIT processing you are attempting by using the On-Insert trigger. You can perform your test of the CheckBox and call the Insert_Record built-in if the test passes. For example:
Sorry for any confusion.
/* On-Insert Trigger */ BEGIN IF ( :MY_BLOCK.CHECK_BOX = 'Y' ) THEN Insert_Record; END IF; END;
Edited by: CraigB on Apr 21, 2010 4:17 PM