Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete - SQL not working, Desperate Need of Help
Message
 
To
01/10/1998 07:43:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00142721
Message ID:
00142736
Views:
38
>>>
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform