>>Hi Fernando,
>>
>>Thank you for your answer. My description of my problem was not that exhaustive, sorry. Your tipp is working in the developement environtment, but I need to change the settinghs in an EXE. Do you know a trick to do it there too?
>>
>>Gerhard
>
>Gerhard, isn't more easy to add "AND NOT DELETED()" in the "WHERE" clause?
>
>The complex situation here is that it is not clear HOW you use the tables in the dataenvironment that you have trouble with the report.
>
>May be you can expand with more details on your report and the tables in the dataenvironment and the like.

I prefer to avoid DELETED() and RECNO() in SQL because they only operate on one alias. It is always safer to SET DELETED ON before running a command.