||Re: Filter in rowset
Akshat Kapoor <firstname.lastname@example.org>
||Fri, 19 May 2017 23:08:51 +0530
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