>Are you sure you can't? I mean, do you SELECT ... FOR NOT DELETED()? Do you have SET DELETED ON?
>
>>Hi all,
>>
>>I'm using updatable views in an app. I'm wanting to reuse deleted records. The only way I can find to recall the record in the table is actually selecting the table and issuing a RECALL. Doesn't this defeat the purpose of using views? Can I recall a record through the use of a view? If so, How? If not, what's the best way to handle this?
>>
>>TIA
I'm not having a problem selecting the deleted records. I can select a deleted record into a view. The record in the view shows as being not deleted. If I recall it, 0 records are recalled because according to the view, it's not deleted. When I issue the tableupdate(), the changes I made get written back to the table, but the record is still marked for deletion in the table. I've even tried deleting the record in the view thinking maybe it would toggle the deleted mark of the record in the back-end table, but deleting it in the view just re-deletes it in the table. So, any other ideas?
P.S. I don't think the status of SET DELETED affects SQL-SELECT statements. (but I may be wrong)
_________________________________
There are 2 types of people in the world: