Hi,

In before.program section of a newly developed session, I want to filter data displayed based on specific date range. I am writing following in my program script:

query.extend.where(" whinh312.ardt >= " & filter.ardt.f, EXTEND_APPEND)
query.extend.where(" whinh312.ardt <= " & filter.ardt.t, EXTEND_APPEND)

I am getting following error:

Error: Illegal type combination: 'string & long'

Can anyone help, how can I specify such selection criteria.

Thanks in advance,
Vishal

It seems filter.ardt.f and filter.ardt.t are numbers, not strings. Try:


query.extend.where(" whinh312.ardt >= " & str$(filter.ardt.f), EXTEND_APPEND)
query.extend.where(" whinh312.ardt <= " & str$(filter.ardt.t), EXTEND_APPEND)

Is In Extend_append mode it concate two query.extend.where with "and' logical operator ?

Yes, EXTEND_APPEND uses the "and" operator. But you can also code the "and" operator in the where clause itself. Example:

query.extend.where("whinh312.ardt >= " & str$(utc.num()) & " and whinh312.ardt <= " & str$(utc.num() + (24*60*60)))

Is There Is Any Way To Concate It Using "or" operator

Hi,

As Jaap mentioned, you can write whatever statements you want OR/AND , but for concatenating conditions (strings) you need & operator.