Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dirty buffer due to changed non-updatable fields
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Application:
Desktop
Divers
Thread ID:
01398015
Message ID:
01398017
Vues:
61
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform