General information
Category:
Internet applications
>>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only