https://www.appeon.com/standardsupport/search/view?id=4199
Jan, i read your bug report. They didn't understand that you are talking querymode, NOT datawindow design mode. Querymode is at runtime, but Armando must have thought you are talking about design time which is why he suggested the sql statement.
anyway, the datawindow will ASSUME the IN keyword is the operator of the sql statement when it is the FIRST thing entered in the column when in querymode. It does NOT send this to the database to validate it, it simply ASSUMES. It does the same with other keywords such as LIKE = <> etc.
In your case, if you want to search on 'IN-' that then you MUST enter another keyword such as '=' OR LIKE before typing IN. ( querymode will automatically enter = for the generated where if the first word entered is NOT a keyword)
anyway enter either of the following in querymode:
= IN-
LIKE IN-
also, if you do NOT want to be forced to type in = sign, you can capture the text the user types and then overwrite it with what they want. it takes some coding to do that.
