<br><font size=2 face="sans-serif">A colleague has an issue with
data being overwritten and some inserted by a feed from a plant system.</font>
<br>
<br><font size=2 face="sans-serif">If we look at the table below rows above
the cursor may have been updated with new results or just be values which
were there in 2006.</font>
<br>
<br><font size=2 face="sans-serif">the rows including the cursor row and
below didn't have values in 2006 and have been inserted on 28-apr-2020
</font>
<br>
<br><font size=2 face="sans-serif">The issue is caused by the actual mill
roll number recycling in the plant system (don't ask why) and the application
which fills this table and others not realising that this is an old mill
roll.</font>
<br>
<br><font size=2 face="sans-serif">The data clearly should be archived
off occasionally and there is a good reason why this didn't happen. </font>
<br>
<br><font size=2 face="sans-serif">So here is the question -<b> I / we
assumed that rows inserted (after 28-apr-2020) would have a recent
tuple id but if we look at the table it's clear they don't.</b></font>
<br><font size=2 face="sans-serif"><b>We are pretty sure that the answer
to our question - Is there a way of working out when these rows came into
the system? - is that there isn't but we decided to ask anyway. It
surprised me that the tids were sequential. </b></font>
<br>
<br><font size=2 face="sans-serif">The tuple ids for rows which have genuinely
been added recently are considerably higher than the ones in this table.
</font>
<br>
<br><font size=2 face="sans-serif">BTW a quirk of the plant system means
that not every new mill roll after a certain time is a duplicate.
In fact very few overlap. </font>
<br>
<br><font size=2 face="sans-serif">If anyone has any ideas ...........
</font>
<br>
<br><font size=2 face="sans-serif">thanks</font>
<br><font size=2 face="sans-serif">Allan & Benoit </font>
<br>
<br><img src=cid:_1_135D6CA4135D6A6400530F5B80258576><BR/><p><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties</p>
<p>Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean</p>
<p> http://www.DuPont.com/corp/email_disclaimer.html</p>