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
View originalHi
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
