Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Ed,
>Don't recirculate keys is the best solution. AN alternative that gives some partial success is to embed a FOR clause in the index, but recreation of the index can be an issue, it will not be usable for Rushmore optimization, and should you ever try to recall a recirculated key or do not properly regulate reallocation of n out-of-sequence key in recirculation, you invite lots of trouble. You also create problems if you ever move from the native VFP file system, whose concept of records flagged as deleted but still present is not very portable.
Hmmm, When upgrading I wonder why you should include deleted records? If you don't upgrade the deleted records this should not be a problem at all.
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only