LEGACY CONTENT
This article refers to legacy products, components or features. Therefore, the content in this article is offered "as is" and will no longer be updated. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Introduction

An error occurs when performing a SQL-like DELETE query when using the K2 ADO.NET Provider. Using synax like: "DELETE from SmartObject WHERE SO_Column=’xyz’" or "DELETE from SmartObject WHERE SO_KEY_Column=5" will currently fail.

Error Scenario Steps

Note: The steps below describe one scenario under which this error may occur. The steps below are simplified and not all the steps will be shown or described.
  1. Create a custom ASP.NET page that interacts with a K2 SmartObject using the K2 API
  2. Create a custom DELETE statement using SQL-like syntax
  3. Run the ASP.NET page and attempt to perform the DELETE function

Error Messages

The following error messages relate to this issue:
  1. Incorrect syntax near DELETE clause, Required parameter 'id' for method 'Delete' must have a value

Error Resolution

This Hotfix is contained within the latest K2 blackpearl 0807 Update. Install the update package to resolve the error.

The latest K2 blackpearl 0807 Update is available as an independent installation package which can be found here: https://portal.k2.com/downloads/bp/default.aspx.