Good day
=-=\=-=\=-\
I only can provide a way I would test it to see if there is a way to fix
the problem. I
hope that this will be helpful.


At 04:32 19/05/2004, you wrote:

>It is strange:
>
>What will happen is a 'ghost' record will appear. If I do a:
>
>Select * from taxpassoff where Propid = 1220000000
>
>I will get four records (All showing that they have AssessmentYear = 2004)
>
>If I change the select to:
>
>Select * from taxpassoff where Propid = 1220000000 and AssessmentYear = 2004
>
>I only get 3 records. AssessmentYear and PropID are both INTEGERS.
>
>If I change the select to:
>
>Select * from taxpassoff where Propid = 1220000000 and
>cast(AssessmentYear as INTEGER) = 2004
>
>I will see all four records.
>
>This table may have 120,000 records in it and every once in a while
>there will be 1 to 4 records that have done this.

You can try by updating these values in question to itself, to do a force
rewrite of the
value and see if it corrects the query problem,

you can run for instance

update taxpassoff set AssessmentYear = AssessmentYear where Propid = 1220000000

then redo your select

Select * from taxpassoff where Propid = 1220000000 and AssessmentYear = 2004

If this still returns 3 rows then do this update

update taxpassoff set AssessmentYear = 2004 where Propid = 1220000000

then do the select again.

If it then returns 4 rows then there is a possible index corruption on
writing the index values.

Out of interest sake, how many rows and columns does this table in question
have at the moment ??


I hope it helps

Johannes

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004


[Non-text portions of this message have been removed]