Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ignoring deleted records in a SEEK
Message
From
14/03/2000 21:16:18
 
 
To
14/03/2000 18:55:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00345465
Message ID:
00345639
Views:
21
SNIP
>
>Important SET DELETED is ignored if the default scope for the command is the current record or you include a scope of a single record. INDEX and REINDEX always ignore SET DELETED and index all records in the table.
>
>SET DELETED is scoped to the current data session.
>
>In other words, a SEEK is only scoped to a single record and is not affected by the setting of SET DELETED.
>
SNIP

Hi Jack,

This excerpt lost me $20. 5 years ago. It simply ain't so with SEEK, even though it *is* scoped to a SINGLE record. In other words DELETED's setting is respected for SEEK.

Jim N
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform