AnsweredAssumed Answered

Omit item in ExecuteSQL statment

Question asked by MikeWile on Oct 11, 2016
Latest reply on Oct 11, 2016 by beverly

I have a field with the calculation below. What I'd like to do is omit an item when ISBN_JBP FROM tbl_CisPub_ProductMaster_cache = origisbn. Right now, it's included in the list. I've tried adding an additional SELECT statement in parentheses after the ? but it showed an error. Any suggestions? Thanks.

 

Let ([pgrp=tbl_CisPub_ProductMaster_cache::PGROUP;origisbn=ISBN13]

;

ExecuteSQL ( "SELECT \"ISBN13_JBP\" FROM \"tbl_CisPub_ProductMaster_cache\" WHERE PGROUP=?"; "" ; "";pgrp ))

Outcomes