>I've tried the same thing. Although the datetimes look the same, they aren't. Go to one of the duplicates, save it to a variable, skip to the next record, and save it to another variable. Now, if you do an equality test on the two, FoxPro says they are different.
Interesting...they are different, but not unique for index purposes :)
>
>It appears to work fine if I do the following:
>
>ldCount = {^2001-01-01 12:00:00AM}
>lnCount = 0
>SCAN
> REPLACE PKEY WITH ldCount + lnCount
> lnCount = lnCount + 1
>ENDSCAN
>
>
I almost went that way...but I didn't think it would make difference (plus I was tired of the problem). Thanks for trying it...
>It definitely looks like a rounding issue to me. The first one avoids the small rounding error by always adding to the initial date from scratch. The second one will force the datetime to remove any fractional pieces after each addition.
>
Yes, it must be. All is well in the world of the Fox.
Steve Gibson