Hi DAW,
This bug still exist in DF18.1 (A3) - See original post
Issue exist in both dbSuggestionForm & cWebSuggestionForm
Basically, the SQLStrLike function needs to check whether DF_DRIVER_IGNORE_UCASE_SUPPORT is supported or not.
If ((IGNORE_UCASE_SUPPORT=False) and (pbCaseSensitive=False)) then it should produce a Like statement as per:
Code:
UPPER(File.Field) LIKE '%searchtext%'
where searchtext is uppercased
OR:
Code:
UPPER(File.Field) LIKE UPPER('%searchtext%')
Rather then the standard:
Code:
File.Field LIKE '%searchtext%'
Thanks