Double check the values of dates in the WHERE clause.
>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
>>>
>>>
--sb--