Autocomplete CharCase property half working ?

[duffo64]

Hi,

It's nice to have the charcase property, but I cannot understand why, even if the char case is ok at screen, my query does not work, like if case is not converted at all under the hood, e.g.:

- set autocomplete char case to lower
- my query is: SELECT LOWER(table.column) FROM etc.etc....
- lock caps on keyboard and input a string
- no joy

If I keep caps lock off all is working again. Is this a bug, or am I missing something ?

Thanks

Claudio

[Jorge Sousa]

Hi Claudio

You have to set FilterOptions of your Query to [foCaseInsensitive]

Best Regards

[duffo64]

Whoops !

Thanks !

Claudio