That did it. Thanks Sergey.
>>SET DELETED was already ON, and I'm still getting the deleted record. Thats why I tried
>>the NOT DELETED(). I'm open to suggestion.
>
>You cannot get deleted records with SET DELETED ON unless you're quering not saved buffered data. You either have to save pending changes or add
WITH (BUFFERING = .T.) to the query.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people