General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Hi Claude
>>>1. Why does table Tx have fewer records then table x?
>>
>>The original table has deleted records. So, they are not missing. You can use count function to see how many active records are in the original table.
>>I bet you will have the very same number with select statement
>>
>>>2. What is the best way to find what records are missing?
>>
>>DO you need deleted records too?
>
>I think so. It would be the safest way to go.
Thanks that was it. I save current value of "Deleted", set "Deleted" to OFF and then reset it.
Previous
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