Incorrect Syntax near the keyword 'WHERE' error

  • 30 January 2015
  • 0 replies
  • 1 view



 

Symptoms


Error message "Incorrect Syntax near the keyword 'WHERE'" when using update method of the SQL smart object to pass NULL value into field of DateTime type.
 

Diagnoses


This is known issue which exist both in 4.6.7 and 4.6.8: Unable to pass NULL value when executing UPDATE method for DateTime format column of SQL Server SMO both from SmartObjects Services Tester and from the SmartObject Event in the workflow.

 

Resolution

This is known issue which is slated to be addressed in future versions of the product (post 4.6.9).




 

0 replies

Be the first to reply!

Reply