Is there any way to fetch automaticaly changed record to form when the error FRM-40645 "Record has been updated by another user. Re-query to see changes." occurs. Executing whole query is too expensive.
I think your changing data values at table level in your database by using a procedure in/from your form.
This is something you can do because you are using the session_id who is locking records at table.
Try not to change table values but record block values or you will go on getting the same error.
Otherwise, you will have to requery to see changes.
Thanks, but I allready found, what i was looking for:
1. Save rowid
2. Create new record and fetch all the item from database using rowid of the record
3. Assign rowid to the new record
4. Change record status to QUERY_STATUS
5. Clear old record from form