Subject Re: Filter in rowset
From Akshat Kapoor <>
Date Fri, 19 May 2017 23:08:51 +0530
Newsgroups dbase.getting-started

On 19/05/2017 14:48, Juan Antonio wrote:
> /*
> // -----------------------
>  I'm trying to make a filter in a rowset of a Query by comparing the value of one field with another.
> It works if I do it in an SQL statement
>   "Select * from table1 where field1> field2"
> In the Filter help says it can be put as in the WHERE clause of a SQL SELECT.
>   But when I do the same with a filter it gives me error "operation not applicable"
> Can anybody help me ?
> Thanks in advance

Was experimenting further
       filter := "field1 > 22"
works well but
       filter := "field1 > field2" doesnot work.
It seems right hand side must be a fixed value for filter to work, It
cannot be another field.
Senior programmers will be able to tell you better.

Anyway try the canGetRow event. You can build even complex filters using
this event.