>>Is there any way (short of packing the table) to get seek() to not read deleted records?
One simple way is to include NOT DELETED() in the filter of the index. That can mess up Rushmore, but it beats packing.
Another way is to SET FILTER TO NOT DELETED(). I haven't done that with SEEK(), but it's worth a try.
Bill Fitzgerald, MCP
Woodbury Systems Group
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
