Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wishlist: SET RECYCLE on and Index on Deleted records
Message
From
11/10/1999 10:46:02
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Wishlist: SET RECYCLE on and Index on Deleted records
Miscellaneous
Thread ID:
00274835
Message ID:
00274933
Views:
36
Jess,

>I think Filtered Index will do for that matter.

>INDEX ON itemid TAG itemid FOR DELETED()
>SET ORDER TO itemid

The SET RECYCLE option has nothing to do with any itemid, It only consernes records where the deleted flag is set. it should only contain info about which records are deleted. info about any field only takes up valuable diskspace.

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform