>>>>>Hi everybody,
>>>>>
>>>>If I understood correctly:
>>>>
>>>>local laCount(1)
>>>>select count(*) from childTable where condition matching filter command into array laCount
>>>>
>>>>if laCount(1) > 0 then there are matching records
>>>>
>>>
>>>I think using select-sql was not a way for me, but I just added COUNT FOR condition in the SetFilter() method of the form and it worked well.
>>
>>But you did not want to (or preferred not to) move the pointer, something that COUNT FOR will do.
>
>Yes, that's true. But I have LOCATE command after COUNT is done, so everything seems to be OK.
It seems to be OK, but it is not. The SQL command that Hugo gave you is a good way to do this. By using SET FILTER and COUNT and LOCATE you are causing the computer to do much more work than it should.