>>I built my application as executable file. However, when I run the executable file, all the deleted records are not ignored and are shown up. When I built it, I changed the option to "ignored deleted records". Is there any other thing I need to do so that those deleted records will not be shown up? Thanks.
>>
>>Chu
>
>If you are using private datasessions in your forms, you must add 'SET DELETED OFF to each form. Put it in your LOAD method.
>
>If you are using the Default datasession, then put SET DELETED OFF in your main program.
>
>HTH
Performance will also improve for SQL SELECT, if you provide an index for each table: Index on Deleted() tag ItsDeleted
This allows SQL to enforce the SET DELETED filter from the index file, without having to make reference to the table itself.