Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: "Incorrect Syntax Near '='" Error Message When You Delete Multiple Orders in BizDesk


View products that this article applies to.

Symptoms

In Commerce Server 2002 or Commerce Server 2002 SP1, you receive the following error message when you try to delete multiple orders in Business Desk (BizDesk):
Error:
The record(s) could not be deleted.
Number: 0x80040E14
Description: Line 1: Incorrect syntax near '='.
Source: Microsoft OLE DB Provider for SQL Server
Help File: Help Context: 1000440

↑ Back to the top


Resolution

To resolve this problem, obtain the latest service pack for Commerce Server 2002. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
328814� INF: How to Obtain the Latest Commerce Server 2002 Service Pack
Note After you install Service Pack 2, you must manually update your BizDesk file before you start Commerce Server BizDesk. To do this, copy the Orders_util.vbs file from the Program Files\Microsoft Commerce Server 2002\sp2\bizdesk\orders\include folder to the corresponding BizDesk application folder. For more information, see the ReadMe_sp2.htm file. This file is located in the Program Files\Microsoft Commerce Server 2002\sp2\ folder.

↑ Back to the top


Status

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top


More information

This issue exists only in BizDesk for Commerce Server 2002 and Commerce Server 2002 SP1.

Steps to Reproduce the Behavior

  1. Create two orders in the Commerce Server 2002 Retail site.
  2. Start BizDesk.
  3. On the Module Order menu, click Order Status.
  4. In the right pane, click All orders in the drop-down list box.
  5. Select one of the orders that you created in step 1 (order A).
  6. Select the other order that you created in step 1 (order B).
  7. Cancel the selection of order A.
  8. Select order A again.
  9. Click Delete.

↑ Back to the top


Keywords: KB825656, kbbug, kbfix, kbcommserv2002sp2fix

↑ Back to the top

Article Info
Article ID : 825656
Revision : 3
Created on : 8/13/2003
Published on : 8/13/2003
Exists online : False
Views : 343