>I use a prg containing only app. 20 select queries.
>They give the right results except the one I enclosed.
>It results 0, which obviously false.
>The interesting thing is that when I make a selection of the
>code snippet enclosed and click on "Execute selection", it gives the right result.
>Any idea?
>
>

>lcDateInd = {2010.01.01 00:00:00}
>lcDateErk = {2010.02.01 00:00:00}
>lcDateStor = {2000.01.01 00:00:00}
>
>
>SELECT count(bp_eng_uh.engkod) as db;
>from bp_eng_uh;
>where bp_eng_uh.alairva >= lcDateInd;
>AND bp_eng_uh.alairva < lcDateErk;
>AND bp_eng_uh.stornozva < lcDateStor;
>into cursor osszesUH
>
>

Are you sure that the third date would be ten years ago? Any transaction signed in January 2010 couldn't possibly be cancelled before 2000.