General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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