Page 1 of 1

Autocomplete CharCase property half working ?

PostPosted: 05 Nov 2013 07:45
by 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

Re: Autocomplete CharCase property half working ?

PostPosted: 05 Nov 2013 10:51
by Jorge Sousa
Hi Claudio

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

Best Regards

Re: Autocomplete CharCase property half working ?

PostPosted: 05 Nov 2013 16:59
by duffo64
Whoops !

Thanks !

Claudio