Brian Dunning's FileMaker Custom Functions

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   Tim Anderson
Tim Anderson Group

Share on Facebook Share on Twitter

  Sample input:
list.ToSqlIn ( "what¶can¶I¶find¶")
  Sample output:
( 'what', 'can', 'I', 'find', '')

  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.

 

Comments

esc   esc, tokyo
Apr 22, 2018
Single quote in value should be replaced with two single quote.

list.ToSqlIn ( "I'm¶not¶heavy¶")
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.