Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete - SQL not working, Desperate Need of Help
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00142721
Message ID:
00142736
Vues:
39
>>>
>>>select entry
>>>locate for entryid = m.lckeyvalue
>>>delete
>>>	
>>>select entrydet
>>>locate for entryid = m.lckeyvalue
>>>delete
>>>
>>>
>
>Exactly my point. You should delete record in the child table first, then parent (I know, you have "ignore" in your rfi rules, but still a nice habit, don't you think?). And yes, Fox 5 sounds like a natural way to go, even Fox 6, but I haven't done that either...

Right, the child goes first... all the rfi's are gone but still no joy. Is it because the view is open, surely not, otherwise we wouldn't have requery. This has me stumped. Still it's late in NZ so maybe that's it...

- love the quote and bubbles
Sarah King
pcpropertymanager.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform