Does anyone know if the ExecuteSQL function will handle the IN() function? Either it doesn't or I can't get it to work. Here's the code:
ExecuteSQL ( "SELECT field FROM table WHERE field2 IN ('a', 'b', 'c', 'n')"; ""; "" )
The goal is to load an array for the IN that holds record IDs of a found set. Then I can use sql to "constrain" the records.