Keri Taylor

Help with NSQL parameters

Discussion created by Keri Taylor on Nov 7, 2008
Latest reply on Nov 10, 2008 by Keri Taylor
Can someone help me with the differences between these @WHERE statements and why would i construct the parameter statement these ways.  WHERE ...AND     (flat.branch_unit_id = @WHERE:PARAM:USER_DEF:INTEGER:OBS@)or like this... AND (flat.branch_unit_id IS NULL OR @WHERE:PARAM:USER_DEF:INTEGER:flat.branch_unit_id:OBS@) or like this...AND     (@WHERE:PARAM:USER_DEF:STRING:r.unique_name:RESOURCEID@) Thanks for any help you could provide.  FurRelKT 

Outcomes