I just tried to put the code snippet in question in a separate prg and it worked,(but the original did not).
>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
>>>>
>>>>