What I am trying to do logically is
if(#prompt('pmt','INTEGER','-1')# > 0)
then(
data item in (select * from table where id = #prompt('pmt','INTEGER','-1')#)
)
else(
do nothing
)
I know the filter will except something like
dataitem = if(1=1)then( 1 ) else ( 0 )
but I don't see a way to solve this problem with that syntax.
Thank you
if (a) then
(b)
else
(c)
Use:
(a and b) OR ((not a) and c)
Just thought I would share