I have question about api_Datasource.deleterow.

I have grid, in the grid selected 10 records. On the delete button execute this code: decalre p_row_id number := api_Datasource.getcurrentrowid(p_ds); begin api_Datasource.deleterow(p_ds); api_Datasource.doCommit(p_ds); Exceptiom When othres then api_datasource.refreshrowbyid(p_ds,p_row_id); show error end; Is all ok this record deleted from DB and record from grid, but if record have child records i get error: "ORA-02292: integrity constraint (RPK.RPK_RPGT_RT_FK) violated - child record found" (I'm understand this error), after this error fire api_datasource.refreshrowbyid(p_ds,p_row_id), but record don't back to grid (i can't see on the grid). I see that record status (BDF_STATUS_CD=NULL).

What should I do, that record back to the grid ?
I can't make api_Datasource.executequery, because im using infinity scroll (100000 redords) and after failure delete i would like to put curosr to same record, which want delete.


asked 09 Dec '15, 04:00

AlfAbetas's gravatar image

accept rate: 11%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 09 Dec '15, 04:00

Seen: 1,101 times

Last updated: 09 Dec '15, 04:00

© Copyright Gerger 2017