K2 is throwing a SQL error.

  • 27 September 2016
  • 0 replies
  • 2 views

Badge +4


 

Symptoms


K2 is throwing a SQL error "Incorrect Syntax near the keyword WHERE". Not sure how to debug, since the SQL is generated behind the scenes.

 

Diagnoses



A good place to start is to review the Action that triggers the error. In this case a Buton on a Form. Once identified which triggers the error, reviwing the rules is the next step. If there is something missing in any rule a word with a dotted line under will be visible.

 

Resolution



One of the rules for a SmartObject was missing an identifier (WHERE clause). Adding the missing property resolved the issue.
 




 

0 replies

Be the first to reply!

Reply