>Thanks Elmer, I already understood that. I was trying to point out that the SQL SELECT would pick up the deleted records in an uncommited table/cursor.
Do you have a CoDe magazine called VFP9 Focus? The first article talks about changes in SQL in VFP9 and other data enhancements.
If it's not broken, fix it until it is.
My Blog 
