Re: Discarting changes in Block without refetch whole block

I think your second solution is the best. You probably can make it generic for other blocks by referencing system.trigger_block and moving along the items in the block (NEXT_ITEM built in I think) checking for changed base table items.

hope this helps,
Dominic
Jan Januska wrote in message <352C9045.1F93_at_sh.cvut.cz>...
>Hi all!
>
>I have a block in Forms 4.5.
>
>When i navigate between records in block, i check if record current
>record is changed. When is changed, message appears "Save Yes/No".
>If i select No, I want reset that record to starting values (when fetch
>from database).
>I have some ideas solving that problem but are little "dirty".
>
>1. Clear block, Execute_Query and Go_Record
>
>This solution is time-consuming when plenty of record are fetch
>
>2. set all items values to DATABASE_VALUE and mark record as QUERY
>
>This is more better, but is not universal for another block. I don't
>know how to create library procedure having as parameter name of block
>
>Has anybody clearly solution?
>
>Thanks Jan Januska
Received on Fri Apr 10 1998 - 00:00:00 CDT