Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange problem with DELETE and Grids
Message
From
15/06/2009 13:15:18
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01405737
Message ID:
01406134
Views:
45
Thanks, that solved the problem.


>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform