6/6/2025 11:25:40 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.
|
|
|
|
Case Sensitive Sorting in a Datagrid
Posted: 12 Apr 07 1:03 PM
|
fiogf49gjkf0d I asked my BP to post this in the BP newsgroups, and they told me a few days ago that there had been no reply - so I thought I'd venture a try in this newsgroup to see if anyone can help or has at least seen this before.
I have a tab under a custom events module that displays all the registrants for the event. The only thing on this tab is a datagrid. It populates correctly, but my problem is that if the user tries to sort by the registrant's name, it sorts in case sensitive, which means it sorts all the capital letters A-Z first, then does the lower case letters a-z after that, like
Adams
Mitchell
Smith
Zabrowski
brown
kartchner
vickers
This is really a problem because you have to search for a person in practically two different registrant lists on the same tab. I checked my database, and the collotation is set to Case Insensitive (as everything else works the way it is supposed to), and I even completely rebuilt the tab with a new datagrid. Also, this was occuring before I upgraded to v7 from v6.2.3.
Does anyone have any ideas why I am seeing this? Is there a setting on the datagrid that might be causing this?
Thanks!
Jeff |
|
|
|
Re: Case Sensitive Sorting in a Datagrid
Posted: 12 Apr 07 3:29 PM
|
It sounds like the field your sorting on has a binary sort order.
From sql ent. do a generate sql script to look at the Collate token.
If its wrong I'd rename the table and regenerate it with the correct collate order and move the data back. Or you can select the data using a Collate token and forse the correct order. |
|
|
|
Re: Case Sensitive Sorting in a Datagrid
Posted: 16 Apr 07 9:28 AM
|
Sorry about taking so long to respond...
Funny thing about that field you recommended I check - it is a SalesLogix calculated field on the contact table called Contact Name (Last, First), or NameLF. I looked at it in the calculations manager just to see if there was indeed something funny about it, but there wasn't. So, just to see what happened, I had it display the account name instead, which in our database is the same thing. It still didn't sort correctly - and just to make sure, I checked the collation on the Account field as displayed in SQL Management Studio, and it is Case Insensitive.
Thank you for your post, though! Does anyone else have an idea of what this might be. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|