It's possible if temp is a view with uncommited changes. A query will not see those changes.

>I made a select sql like this:
>
>Select * from temp;
>where temp.total >= 40000;
>into cursor temp2
>
>temp.total is a numeric field(9,3) and although this select sql always worked correctly and there are records which meet the condition, now it results none.