mibuso.com

Microsoft Business Solutions online community
It is currently Fri Dec 19, 2014 5:34 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Problems with: SELECT ... WHERE ... LIKE 'S%' ...
PostPosted: Mon Nov 14, 2011 5:14 pm 
Offline

Joined: Wed Nov 24, 1999 7:01 am
Posts: 582
Location: Aalborg,Denmark
Country: Denmark (dk)
(Using R2 - Classic - reproduced in several builds, most recent is 32813)

Encountered a strange problem today ](*,)

The Customer is in the Item List setting a filter on Item No. like this: "S*" (All Item Numbers starting with capital S)
This result is fine, until the user clicks Ctrl-Home to go to the top of the list. Then all records disappear :-k
It works fine for other letters, it seems to be a problem with S.

Did some testing and I can reproduce the problem in all databases using the Danish Windows collation (CS and AS). In databases using a SQL-Collation it works fine, so it seems collation related.

I then used Client Monitor to look at the SQL statement:
SELECT * FROM "MyCompany$Standard Text"
WHERE (("Code" LIKE 'S%'))
ORDER BY "Code" DESC OPTION (OPTIMIZE FOR UNKNOWN,FAST 10)

Executing this statement in a query window in SSMS resulted in an empty dataset. Doing it without the WHERE clause, or with a different letter all seems to work fine.
Examples:
'S%' - Incorrectly always empty
'HS%' - Incorrectly always empty
'SE%' - Ok
'%S%' - Ok

What the h... is up with SQL and S% :shock:

_________________
Regards
Peter


Top
 Profile  
 
 Post subject: Re: Problems with: SELECT ... WHERE ... LIKE 'S%' ...
PostPosted: Mon Nov 14, 2011 8:21 pm 
Offline

Joined: Wed Nov 24, 1999 7:01 am
Posts: 582
Location: Aalborg,Denmark
Country: Denmark (dk)
I guess I found the problem: http://support.microsoft.com/kb/971780/EN-US :bug:

_________________
Regards
Peter


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: