list.ToSqlIn ( theList )
return delimited list to a string that can be used in a sql Where
Average rating: 1.0 (1 vote) Log in to vote
Tim Anderson - Show more from this author
Tim Anderson Group
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Used to convert a list (often results for a find or UIDs from a related table) to a string I can use when creating a ExecuteSQL query. Very simple check for numb ears vs text. May well be something in the library that does a better job, but works well for me.
Apr 22, 2018
Single quote in value should be replaced with two single quote.
list.ToSqlIn ( "I'm¶not¶heavy¶")
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.