Re: Forms 4.5 Problem (Record Locking)

In article <8dka4d$cm5$1_at_nnrp1.deja.com>,   pol15_at_my-deja.com wrote:
> Can anyone help with this?
>
> Thanks,
>
> Pol.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Hi,

this is normal Forms-behavior.
if you change a field in a record by pressing a key, forms marks this record as changed and locks the record.
The record remains locked until you commit the change or rollback the changed record.
But rollback is only made, if you do this explicit. Answering the question "Do you want to commit" with no, will not perform a rollback.
If you want to do a rollback on a special record, you have to clear the record (clear_record), clear the block (clear_block) or clear the form (clear_form) programmatically or by pressing a key or button in your application.
E.g. you could, if the user answers "No (do not perform a commit)" clear the record from the form with "clear_record". the disadvantage of this solution is, the the record is no longer in your form. If you want to show the record in his original state, you have to requery the record

Greetings
Martin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 20 2000 - 00:00:00 CEST