I believe you will find this task impossible, because there is no SQL equivalent to RECALL (RECALL is a very XBASE concept), and the way that views communicate to their underlying tables is through SQL.
Nancy- there should be no problem getting deleted records into a view, but once they are there, they are not marked as deleted, so you can't RECALL them.
Chad, my first question is why do you feel you need to reuse records? Generally, (except on a VERY high volume table) disk space is usually not enough of a problem to warrant this.
If you decde you absolutely need to RECALL records, then you will have to do this through the base tables. If you are working primarily throught views, then this is a multi-step process
1. Find the recod in the view that you need to recall, and grab its id
2. Open the base table, RECALL the record with that id, (DON'T clear the fields, or you won't have a way of finding the record later!)
3. Requery the view, LOCATE you recalled record, and do you updating
Knowing that this is what is involved... do you still want to?
>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
Erik Moore
Clientelligence