>>>SET DELETE must be ON to get rid of deleted records.
>>>
>>>About formatting - I'm not yet sure - I believe ToString() has overloads allowing formatting or you can probably look at String.Format()
>>
>>That's what I meant. SET DELETED is ON. I still get deleted records. Is there a setting in NET?
>>I have tried many variations of ToString() and Format() but can't seem to get the syntax right. {0:C} is supposed to do it but how to put it into the command line?
>
>If you explicitly set deleted on in your SP, then I don't understand how would you get the deleted records back. Even if the connection has DELETED OFF, SP setting should have override this, I would assume.
>
>For your format question I'm researching it. I quickly checked Convert class and ToString documentation in MSDN, but haven't found an example yet. I recall it in the C# book I had, but I don't have it now.

I don't get it either. WHen run in VFP the SP only returns the non-deleted rows. But in NET I get all the rows deleted and not. Can you run a PACK on a temporary cursor? Maybe I'll try that.