A
Aidan Jeffery
Guest
Earliler in this thread you said the problem was with loading records into a temp-table - "The problem as I missed to explain is that the unique key of a temp- table won't allow "CALNO" value when "CALÑO" was already present on the temp-table I´m loading." Where are you loading the records from? Are you loading them from an external file, or are you retrieving them from the database? If you are retrieving the records from the database, is it possible that you have records containing both CALNO and CALÑO in the database? And if so, what is the purpose of the unique index in the temp-table? It is the "unique" setting that prevents CALNO and CALÑO from co-existing in the temp-table. So, does the index need to be unique?
Continue reading...
Continue reading...