>>Thanks. When should I use set deleted on?
>>
>>nick
>
>Normally you always have set deleted on
>It looks like that you have issued delete all somewhere in your app.
>If you want to recall all the records then you can issue
recall all
>Then all the deleted records will be back again.
>In Set deleted is off you can see if a record is deleted by the black marker in front of the record in the browse window
Normally when a record is deleted, it is not really deleted from the table, but gets a deleted mark instead. So the record is no longer visible for the user, but if you wish you can recall them. So it works almost the same as the recycle bin in windows.
With set deleted = on you have the normal behavior: The user doesn't see the records he deleted
with set deleted = off the user can recall the records he deleted