Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SetOrder not working
Message
From
16/04/1998 04:37:12
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00092325
Message ID:
00092430
Views:
20
>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).
*header.click or dblclick, rightclick
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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform