DanielShanahan

ExecuteSQL Discovery

Discussion created by DanielShanahan on May 17, 2012
Latest reply on May 17, 2012 by DanielShanahan

After a bit of trial and error, I discovered that I can grab the contents of a global field and use it with an SQL wildcard (%) and LIKE:

 

ExecuteSQL ( " SELECT name FROM party WHERE name LIKE ? " ; "" ; "" ; "%" & ROLE::partySearch_g & "%" )

 

I am enjoying this new function!

Outcomes