F
Fernando Souza
Guest
No, adding a new index will not rebuild the other indexes. But when adding a new active index, the records will get scanned so that the keys can be added to the new index and in the process, the records are validated to make sure they are all ok based on the definitions, so if you have a mandatory field with the unknown value, you will see the error described. And multiple unknown values are allowed in unique indexes, so I don't think the reason you couldn't find them was due to the fact that the index was unique. Based on the error, it seems there is still a record with the unknown value for the field referenced in the error message (which I am assuming, it is still the date field when you are trying to load the .df). Can you replicate this with a test table? Which OpenEdge version?
Continue reading...
Continue reading...