Skip to Content

PB 12.5.1 visible property expression breaks querymode

I found that querymode will totally ignore a column in querymode (won’t include it in the changed where) if the column has an expression on the visible property where the else results in a 0

Example:

if this expression is on the visible property of a column field:

  if( htype = “S” OR upper(left( describe(‘datawindow.querymode’),1))=’Y’, 1, 0)

and i type a value in the column field when in querymode, querymode will not include the column and value when the retrieve is done.

To ‘fix’ – change the visible expression to:

    if( htype <> “S”  AND upper(left( describe(‘datawindow.querymode’),1))=’N’, 0, 1)

now when i type a value in the column field when in querymode, querymode WILL include the column and value when the retrieve is done.

I wasted several hours rebuilding the datawindow trying to figure out why this wasn’t working.   Hopefully this post will save someone else some time. 

I have no idea whether this bug was fixed in 12.5.2 or 12.6.xxxxx

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply