# 4479 Refreshing Live Query Result Sets or Filtered Tables Can Result in Incorrect Sets of Records

---

I am experiencing a very weird DBIASM behavior with last version (4.43 build 3)

The SQL below produces a correct answer with 52 records, but if I execute the SQL more times, the result sometimes repeat some records but RecordCount still 52 records.

select * from hpev where (coo=101411) order by dat, num

Data sample:

1
2
3
RecordCount = 3

Wrong execution:

1
1
2
2
3
3
RecordCount = 3

When the DBGrid shows the result it is correct but when I press CTRL+END to go to to end of data the problem appears and every record is duplicated.

The table indexes were already rebuilt and there is a secondary index with DAT and NUM (not descending)
This SQL produces a live result