Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete is undoing itself?
Message
 
À
31/10/1999 01:07:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00284455
Message ID:
00284502
Vues:
16
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!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform