Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete is undoing itself?
Message
 
To
31/10/1999 01:07:02
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00284455
Message ID:
00284502
Views:
15
Just a guess,

Is there any RI code in that is restricting deletion if parent record exists?



>I have a form which has an optimistically buffered table in the DE.
>During an edit process I delete some records from this table (which is a child table)
>During the save process I detect the deletions because the GetFldState() returns '21111111' for each record.
>If I browse the table (from the debugger) at this point I can see the delete marks are on.
>I then proceed to the TableUpdate(.T., .T.) command and the records become undeleted. I watch it happen in the browse window
>
>At first I thought is was because I was using the new "DELETE FROM ..." SQL delete which I thought must have been acting on the underlying table rather than the buffered copy. But no, I switched to using SCAN.. DELETE ENDSCAN. But got the same result
>
>I'm now thoroughly confused and am going home !
>
>Any one got a clue?
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform