>>Hi everybody,
>>
>>I have two grids on the form one being related to another. When I select record in the top grid, I filter records in the bottom grid using SET FILTER command.
>>
>>I also fire a ValidateRow method in each of the grids.
>>
>>My problem is that I don't want to run validation if nothing is selected in the bottom (and upper) grids.
>>
>>How can I check (preferably without moving record pointer) if I have records satisfying filter condition or not?
>>
>>Thanks in advance.
>
>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.
If it's not broken, fix it until it is.
My Blog