InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Explain The Following Error: “rows Changed Between Retrieve And Update”? |
|
Answer» It occurs when a USER updates the data before you update it. PB detects it when you include the timestamp column in the DW or use “key and updateable columns” in the WHERE CLAUSE. The solution to the problem would be to use the reselect row () function to reselect the row that caused the error and GET the latest values for the error row and update the DB again. It occurs when a user updates the data before you update it. PB detects it when you include the timestamp column in the DW or use “key and updateable columns” in the WHERE clause. The solution to the problem would be to use the reselect row () function to reselect the row that caused the error and get the latest values for the error row and update the DB again. |
|