Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dirty buffer due to changed non-updatable fields
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Application:
Desktop
Miscellaneous
Thread ID:
01398015
Message ID:
01398194
Views:
61
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.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform