SQL Server does not keep deleted records like VFP does. If you delete a row, it is removed by SQL Server. Recycling records is something that isn't done in SQL Server.
>I know; I was not using RECALL (in VFP). I am setting a certain field value to 'D' and then look for these records (with 'D') and set the value back to empty. So my recycling (in VFP) is not Delete/Recall. So I could, in theory, apply it to SQL Server. But I am trying to simplify my code; hence this question.
>Thank you.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer