Locator not working on Server

[broche]

NT 8.19
CL 9.0
PostgresSQL

App running on the server
Table has a contains locator with the default sort order of Customer Name
Column is Upper case, locator is upper
When I type in the locator, the locate jumps around a lot then does not seem to locate properly.
If I choose another menu option then come back to the table the locator works.

I downloaded the data to my local PC and ran exact same application locally and it worked just fine?

Any ideas?

[Bruce]

when you open the browse for the first time, do you see a "sort indicator" next to the Customer Name header?

given that it's different from your machine to the server, I might be inclined to check the SQL install on the server compared to your one. Especially with regard to collation sequences, utf support and so on. Differences there might explain your issue.

Cheers
Bruce

[broche]

I found I had too many joins going on.  When I simplified the table the locator worked fine and the table displayed much faster.