AnsweredAssumed Answered

SQL Syntax Error

Question asked by glorifindal on Jul 9, 2016
Latest reply on Jul 20, 2016 by glorifindal

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.

 

[quote]

Let([

_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 )

] ;

""

)

Outcomes