The %INLIST predicate is meant to be used against properties of type %List.  Your property is defined as a %String that happens to contain a delimited string of values.

SQLCODE should have contained  an error code when you attempt to fetch the cursor (-400).

To do what your trying to do you could either use the %CONTAINS predicate IE: "...AND routeList %CONTAINS (RouteName)"

Or you could convert the string to a list.  This would convert your delimited string property to a %List, allowing %INLIST to function correctly.


Best solution would probably be to convert the property to %List if possible or even another table.

Hope that helps!