Thank people but nope it didn't work for me. I have tried to TABLEUPDATE() at various places, also did the SKIP / GO TOP thingy but that too no joy. Finally I relented and put in the field in the underlying table and the behaviour is back to normal as would be with regular fields.
>Hi Bhav,
>
>Can you do tableupdate() for your view or it's not an option?
>
>Also I think it may be related to the problem discussed here before.
>
>>Hi all
>>
>>I have a remote view with a column in which the data is being programatically replaced, this column is made non-updateable as there is no corresponding fields in the underlying table.
>>
>>But yet the buffer becomes dirty and when I exit the field and the various setting are triggered and the form goes into an edited status.
>>
>>I have tried to SETFLDSTATE() to 1 for this field, though the improvement is that the form does not show an edited state but when I try to change the record pointer I get the following error
>>Error #: 1545
>>Message: Table buffer for alias "V_SPURCHASEBILLFOOTER" contains uncommitted changes.
>>Line #: 13
>>Code: lnRetVal = REQUERY()
>>Method: requery
>>Object: idatabehavior
>>
>>How can I avoid this completely. I can probably do a TRY-CATCH but that is not what I have in mind. This field / control is in a grid and is set to READONLY = .T. if it matters.
>>
>>Please advise.