hokoba wrote:If you change ANY item in your post-query trigger, even non-base-table items, it causes other triggers to run, specifically the When-Validate-Item on that particular item, and the When-Validate-Record on the row. If, in either one of those triggers, you set or change a value in a base-table column in the record, even setting a column value to null when it is already null, Forms automatic processing will mark the record as 'CHANGED', and lock the record.
Yes, in one place I assign a value to the block item and I commented that line and it works fine..But It is again a non-DB display item..In Property palatte the 'Database Item' is 'No' for this Datablock item. Even if I give commit_form, it is not fruitful . Is there any other way out?
Begin If :System.Mode = 'QUERY' Or :System.Record_status = 'NEW' then Return; --exits the validation process and marks all affected fields as valid. End if; -- validation code below this