NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: broche on July 21, 2014, 08:30:50 AM

Title: Locator not working on Server
Post by: broche on July 21, 2014, 08:30:50 AM

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?

Title: Re: Locator not working on Server
Post by: Bruce on July 21, 2014, 09:51:04 PM

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

Title: Re: Locator not working on Server
Post by: broche on July 30, 2014, 03:49:31 PM

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