>In Portuguese we have some accented words (like José). When I'm indexing my view, I use a function that changes all accented character with the unaccented one, so TiraAcento("José") returns "Jose". So my index is TiraAcento(Upper(nm_employee)), for example. What should I do to have my grid columns sortable ?
>
>Regards,
First set your tag name same as fieldname (index on TiraAcento(Upper(nm_employee)) tag nm_employee).
with this.parent
mcFieldName = upper(substr(.controlsource,rat(".",.controlsource)+1))
endwith
for ix = 1 to tagcount()
if tag(ix) = mcFieldName
set order to tag (tag(ix))
this.parent.parent.refresh
exit
endif
endfor
Cetin