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:
01398017
Views:
60
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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform