I have received a request to enable multiple OR conditions on a query. This requires multiple lines in the dw.
Is this accomplished by inserting rows after turning querymode on or is there another way to do this?
- You are here:
-
Home
-
Q&A
-
Q&A
-
PowerBuilder
- QueryMode - how to show multiple lines
-
Sheldon Shulman
- PowerBuilder
- Friday, 15 March 2019 18:11 PM UTC
if they are grid datawindows, then you will probably see more than the one row since they are usually setup to show more than 1 row.
when you are not in querymode, how many lines do you see? if only 1, then that is because it is sized to show only 1. add a scrollbar and you can scroll to the other lines.
otherwise you need to resize/reformat stuff to show more rows if you really need to have the additional rows.
also, maybe just use 'in' instead of 'or, for example: IN ('ABC', 'DEF')
Example:
IN ('ABC', 'DEF') is the same as (value = ABC OR value = DEF)
IN (1001,1002)
note that numbers do not need quotes, but string/characters do