>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,
Jose,
If you want your grid column to be fully sortable, you have to resort to another collating sequence, like this:
SET COLLATE TO "GENERAL" && fine for Portuguese
do your indexing work here
SET COLLATE TO "MACHINE" && if your original collating sequence was machine.
If you want to learn more about VFP International features, visit Steven Black site (
www.stevenblack.com). If this is not enough I wrote a document about VFP international features a while ago. I must have 2 versions available, in French and Spanish.
José