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

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)

Let ( [ _v = GetValue( theList;1);
	_isNumber = ( _v = GetAsNumber( _v ));
	_quote= Choose( _isNumber; "'";"")
]
;

"( " & _quote & 
Substitute( theList ;"¶" ; _quote&", " & _quote ) & _quote &
")"
)

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, tokyo 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.

list.ToSqlIn ( theList )

Comments

Support this website.

Support this website.