Are you sure you've got the same file opened in both examples

in your code below you have

USE D:\ElszOdosz\uh\bp_eng IN 7 ALIAS bp_eng_uh EXCLUSIVE

is that the same file open in your snipped out example



>Thanks but it didnt help either.
>
>>>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
>>>
>>>

>>
>>Since you're passing datetimes, it will make more sense to name the variables as
>>
>>ltDateInd = datetime(2010,1,1)
>>ltDateErk = datetime(2010,2,1)
>>ltDateStor = datetime(2000,1,1)
>>
>>Also, could it be different SET DELETED setting affecting the output ?