Hi there Community,
I have been trying to use the SQL IN operator.
I'm not even sure if it's a good way to use in Filemaker, perhaps someone could tell me if not.
However, could someone PLEASE tell me what is wrong with the following query.
_val below is actually the results of a variable
It contains a list of ids, which I substituted out to give the format below.
Of course, it could very well be the format of the variable which is wrong.
_val = "('9B0636E5-ABBA-4BCC-A173-D578FEFF7ABD','5F0C33FD-DC23-44EF-B87F-E4CF5D306D86','D43844EA-7800-4470-AECE-329732D1A962')" ;
$_query = "SELECT \"Component Name\" FROM SQLABB WHERE id IN ?" ;
field.sep = "" ;
row.sep = "" ;
$_result = ExecuteSQL( $_query; field.sep ; row.sep ; _val )