>>I had a problem with that as well as the view was being executed before >the Load() event which sets my SET DELETE ON. So, in BeforeOpenTables(), I >had to put SET DELETE ON as well. > >Michel- I can't believe that it was that simple. I thought that SQL didn't >respect the DELETED setting, so I didn't even take it into account. Thanks >a ton for your suggestion. It didn't respect the Deleted setting in the first version which has had SQL (was it 2.0 or earlier) or at least the help said so. Come to think of it, I've always used Set Dele On, and never SQLed with Where not deleted() - and it gave the correct results. Still I vaguely remember having problems with the first version, some six years ago.