Hi Thierry,

Autocomplete search does not seem to work with accented characters, even though query results may contain them.
Is there a cure ?

A. you want to find e or é when typing e

change your CANDIDATE index expression into:

index on cEuroANSI(your Char Expr) tag … CANDIDATE collate GENERAL

Be aware that:

1. You will need to have cEuroANSI() in scope to USE your table ; in other words you'll need the FoxInCloud environment to be loaded.
2. beginning with search will be slower if your table is large (say over 5k records)
3. e and é may sort oddly in the selection list

B. you want to find e when typing e or é

modify class awCboAutoComp of aw method wAutoComp

&& replace
tcQuery = Iif(ga_Type_IsChar(m.tcQuery), Alltrim(m.tcQuery), '')

&& by
tcQuery = Iif(ga_Type_IsChar(m.tcQuery), cEuroANSI(Alltrim(m.tcQuery)), '')

If this feature is useful, we'll add a property in aw.vcx!awCboAutoComp to enable it.

Thanks for your response.

In fact:

3. I want to find e when typing "e" and é when typing "é"

Actually, search with "é" does not work

Would you mind explaining what exactly ‘does not work’ means for you?

• What do you expect ?
• What do you get instead ?

We would save so much time if the problem was always stated right away with full details…

1. When I write gérard, autocompletion don't start

2. When I write dupont, autocompletion starts

Thanks,

Now it's cristal clear, and I can reproduce on the FoxInCloud Live Tutorial: typing 'mère' does not trigger auto-complete on 'Mère Paillarde'.

I'll check and feedback

Hi Vincent

modify class awCboAutoComp of aw.vcx method wcHTMLgen

&& replace
cScript = Textmerge([function(query, process){return jQuery.get('AJAXautoComp.<<m.toHTMLgen.oConfigApp.cApp>>?value=' + query + '&ObjAddr=<<URLEncode(this.wcID)>>', process)}])

&& by
	cScript = Textmerge([function(query, process){return jQuery.ajax({];
	+   [url: 'AJAXautoComp.<<m.toHTMLgen.oConfigApp.cApp>>?value=' + query + '&ObjAddr=<<URLEncode(this.wcID)>>'];
	+ [, contentType: 'application/x-www-form-urlencoded; charset=UTF-8'];
	+ [, success: process];
	+ [});}])

Tested OK on FoxInCloud Live Tutorial

Joyeux Noël !

Thanks Thierry, it works for me 2 !

Merry Christmas