Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set deleted on
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01024306
Message ID:
01024527
Views:
19
This message has been marked as a message which has helped to the initial question of the thread.
>I would like to know if many people here use set deleted on ?
>Is this the better way to keep a record deleted while use
>a table on shared mode, as I can not packed it
>
>Moises

The only time you might need SET DELETED OFF is when checking for table corruption. If a deleted record in a memo table is corrupted at the field level (Error 41) you might not know for months because no regular command (SELECT * FROM etc) will look at the bad field. However, any structural change to the table (ALTER TABLE etc) will fail.

John Burton
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform