Mike,

This isn't correct - SQL Select *does* respect the setting of DELETED. There is no need for an index on DELETED() nor for inclusion of "NOT DELETED("Alias-name")..." in the WHERE clause to gaurd against deleted records being included.

You may be thinking of the situation of a SQL with DELETED set OFF, in which case deleted records WILL be included if they pass the inclusion criteria AND they will be UNdeleted in the result set.


>Mike,
>
>If you use any SQL commands on the table after you have deleted, but not packed a table, remember that the SQL SELECT statement ignores the SET DELETED setting. You therefore should index the table on DELETED(), and include NOT DELETED('tablealias') in the WHERE clause of any SQL command.
>
>David