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:
01398194
Vues:
63
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
___________________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform