Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DELETING by FK
Message
From
20/11/1998 13:13:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
DELETING by FK
Miscellaneous
Thread ID:
00159851
Message ID:
00159851
Views:
62
I have a situation where I need to delete records
based on any one of 100 foreign keys. A total of
about 400,000 records need to be purged.

What is the best way to achieve this goal. I could
do a DELETE FOR INLIST(fk, 2,5,7,8,9,...xxx) but inlist
is limited to 24 expressions.

Perhaps a DELETE FROM tablex WHERE fk IN (sub query)
is the best...
Next
Reply
Map
View

Click here to load this message in the networking platform