Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange problem with DELETE and Grids
Message
 
 
À
13/06/2009 14:05:08
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 SP2
Divers
Thread ID:
01405737
Message ID:
01405831
Vues:
50
>I have a weird problem.
>I have a Form which has Parent and Child table that have usual Relation in DE and Parent have Order.
>
>I have a two grids for both tables also.
>Now, I have dataobject which is custom class that has methods delete, save and cancel which are called through buttons on data toolbar. Dataobject.delete() is simple DELETE and thisform.refresh() and Dataobject.cancel() is simple TABLEREVERT(.T.) and thisform.refresh(). When I press button Delete on data toolbar , data in Parent table is automaticaly deleted and I can't do cancel with tablerevert. But when I put ordinary command buttons Delete and Cancel on Form with direct call DELETE and TABLEREVERT then data in parent can be reverted if canceled.
>Buffering is set correctly to 3.
>
>I don't remember that I run into this strange problem before, so if anyone knows what is about...
>
>I can tell that source of a problem is that Order of Parent table that I put in DE. If I don't put Order then it's ok for both ways.
>
>If anyone has additional questions, feel free to ask.

Boban,

Try to set buffering to 5 instead of 3. In case of 3 any record movement causes the information to commit to the table.
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