I have a form that based on table where ID is primary key, CODE is unique key
ID get value from sequence.
When enter value for CODE, if UK violated, error raised. Then I change CODE to new value and submit page, I have "No data found" message.
The problem is: hidden ID field still keep value and not reset after error.
Does any one know how to solve the problem?
I do not understand the question completely as there are not enough details. But if "ID" is a database column, then the "Source type" should be "Database Column" and the "Source Used" should be "Always, replacing any value in the session state".
Do you have any DML process to update the page items values to the database. If yes, you may try having a page process of the type "Clear Cache for all Items on Pages (PageID,PageID,PageID)" after the DML process is complete.