Hello. I execute a simple BQL query.
SOOrderType orderType = SelectFrom<SOOrderType>
.Where<SOOrderType.orderType.IsEqual<@P.AsString>>.View.Select(Base, tran.SOOrderType);
I verified the BQL parameter returns “SO”
However the results of the BQL is null. I verified that only 1 version of SO order type exists. I’m unsure why this happens.
Best answer by darylbowman
Have you tried trimming tran.SOOrderType? I get caught with this sometimes, but more often with something like InventoryCD.
+15Have you tried trimming tran.SOOrderType? I get caught with this sometimes, but more often with something like InventoryCD.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.