Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
COLLATE |
Mon, May 14 2007 11:02 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Is COLLATE supposed to be OK for in the ORDER BY clause or only in the WHERE clause. If it is meant to be OK for ORDER BY it causes an AV in 1.02. Roy Lambert |
Mon, May 14 2007 5:45 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Is COLLATE supposed to be OK for in the ORDER BY clause or only in the WHERE clause. If it is meant to be OK for ORDER BY it causes an AV in 1.02. >> Are you setting RequestSensitive to True and is the query on a table with text indexes ? If so, then it could simply be the other issue that you reported with respect to using an ORDER BY with a sensitive result set. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, May 15 2007 3:45 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Are you setting RequestSensitive to True and is the query on a table with >text indexes ? If so, then it could simply be the other issue that you >reported with respect to using an ORDER BY with a sensitive result set. Yes and Yes - and I assume COLLATE is allowed in ORDER BY? I'll wait for 1.03 Roy Lambert |
Tue, May 15 2007 5:31 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Yes and Yes - and I assume COLLATE is allowed in ORDER BY? >> Yes. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |