>i made a delete from mytable
>when i make a set deleted off i see all my record
>but when set deleted on i dont see my record
>i want to know how to reput them to not deleted ???
You can use RECALL to recover the deleted records, but in general it is better to consider deleted records as deleted. RECALL should be used for certain emergencies, not as part of your regular process.
For regularly recovering data, you could have some additional field, which marks the record as "deleted", "cancelled", or something similar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)