General information
Category:
Coding, syntax & commands
>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
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