Hi all,
I need a VisibleExpr that flips visibility based on a string inside of our InventoryID -- if an InventoryID contains “-STRING-”, then flip this text on.
=iif(([AMProdItem.InventoryID]='-STRING-'),false,true)
Unfortunately, I don’t know how to write the query so I’m asking if it CONTAINS, not EQUALS.
How do I craft the query to see if the InventoryID contains ‘-STRING-’?
Best answer by jinin
Hi
Could you try like the below,
IIf(InStr([AMProdItem.Descr], '-STRING-') > 0, True, False)
+11Hi
Could you try like the below,
IIf(InStr([AMProdItem.Descr], '-STRING-') > 0, True, False)
Hi all,
I need a VisibleExpr that flips visibility based on a string inside of our InventoryID -- if an InventoryID contains “-STRING-”, then flip this text on.
=iif(([AMProdItem.InventoryID]='-STRING-'),false,true)
Unfortunately, I don’t know how to write the query so I’m asking if it CONTAINS, not EQUALS.
How do I craft the query to see if the InventoryID contains ‘-STRING-’?
Perfect Jini, thank you! I’m not familiar with C# but InStr makes sense now… thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
