Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC Triggers and RI
Message
From
05/01/2013 18:32:55
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01561335
Message ID:
01561530
Views:
60
>Yes, I know about TABLEUPDATE(). My point was that the deletes in the parent and child tables should occur "simultaneously." There should be no need to move the record pointer.

As far as table health is concerned, there is no such need.

It's just that Fox keeps sitting on the deleted record. You may issue a "locate rest" or some such command (even "skip 0" may work, haven't tried in a long time) if you want to make sure you're sitting on a valid record. Also, if you deleted the last record, you may be sitting on eof(), and you know several things which don't work in such a situation.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform