I'd suggest that if you have cut this piece of code that works out of a larger routine that isn't working you must be setting something that causes that in that larger routine.

Why dont you put the code back and then start removing the selects you have before the problem one and keep testing it till it stops working.


>Thanks but it didnt help.
>
>>You should use unambiguous date format
>>

>>lcDateInd = {^2010.01.01 00:00:00}
>>lcDateErk = {^2010.02.01 00:00:00}
>>lcDateStor = {^2000.01.01 00:00:00}
>>

>>
>>
>>>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
>>>
>>>