This content has been marked as final. Show 5 replies
Perhaps the simplest method would be to code your Key-Exit trigger to call the Clear_Form(ASK_COMMIT) or Clear_Block(ASK_COMMIT) built-ins and let Forms handle keeping track of if there are changes. The problem is you can't just check the :SYSTEM.Form_Status global, you would need to check :SYSTEM.Block_Status and :SYSTEM.Record_Status as well since each of these could and typically do have different values even when a change has been made to data in your form.
Hope this helps.
-> But in my situation it's in QUERY status after the above mentioned stage.
Are you SURE? I have never seen any form with Form_Status NOT = 'CHANGED' when a value in a database block was altered.
I think you should do some more testing to check things. If your Form_Status = 'QUERY', then what is the block status of your database block? What is the status of the record that you have changed?
Or are you actually changing values in a control block, and then updating the database via your own update statements? In that case, you should set a package variable or some other flag to indicate that the user has begun entering changes.
Hi Steve Cosner
Thax for the reply.
What you mentioned was exactly correct. I made a mistake here because first tab in my canvas not a database block.
So there status change is no effected. Other tab having thought that data was changed I did this testing. but there was a bug with data change in POST-QUERY
Once again sorry about my mistake....
Thax for everyone who contributed.