Microsoft KB Archive/905861

= You may receive an &quot;Incorrect syntax near the keyword 'group'&quot; error message when you run a program that was created by using the Microsoft CRM SDK in Microsoft CRM 1.2 =

Article ID: 905861

Article Last Modified on 9/8/2006

-

APPLIES TO


 * Microsoft CRM Software Development Kit, when used with:
 * Microsoft CRM 1.2
 * Microsoft CRM 1.2

-





SYMPTOMS
When you run a program that was created by using the Microsoft Business Solutions CRM Software Developers Kit (SDK) in Microsoft CRM 1.2, the program does not run. Additionally, you may receive the following error message:

80040e14

Incorrect syntax near the keyword 'group'.



CAUSE
This problem may occur when you run a program that is similar to the following program.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.    

  

  

 

 <filter type='and'> <condition attribute='actualend' operator='on-or-after' value='2005-07-04T12:42:30' />

<filter type='and'> <condition attribute='actualend' operator='null' /> <condition attribute='modifiedon' operator='on-or-after' value='2005-07-04T12:42:30' />

<link-entity name='activityparty' from='activityid' to='activityid'> <attribute name='participationtypemask' aggregate='count' alias='number' /> <condition attribute='partyid' operator='in'> {5DFDE5AB-75DE-4EB0-B896-5EAA56BC1769} </link-entity> <order attribute='createdon' descending='true' /> This example code creates a Transact-SQL statement on the Microsoft SQL Server side. Inside this statement, &quot;group by&quot; and &quot;order by&quot; Transact-SQL statements are used. This problem occurs when these statements are incorrectly used.

<div class="resolution_section">

RESOLUTION
Microsoft CRM has a fix for this problem that is part of a cumulative update. The cumulative update information is described in the following Microsoft Knowledge Base article:

904435 Update Rollup 2 is available for Microsoft CRM 1.2

<div class="moreinformation_section">

MORE INFORMATION
For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Additional query words: crm12 crm1.2 sdk

Keywords: kbprogramming kbautomation kbmbsmigrate kbpubtypekc kbqfe kbhotfixserver KB905861

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.