Extra WHERE clause in my update statments

• 
  Hello,
  
  Thanks for contacting us via the forums. I did some research on this issue and it looks like we have seen this when specifying the keyword "where" in the where clause editor.
  
  To fix this issue:
  
  - Open the where clause editor
  - Change "WHERE Customer_ID = 11" to "Customer_ID = 11"
  
  That should fix the deployment script from entering the "where" twice.
  
  Hope this helps!
  
  Best Regards,
  Steve

  stanori August 13, 2014 14:43

  - 0 +
• 
  I made that change and now my WHERE clause doesn't cause the update statement to fail but it still looks incorrect to have the Customer_ID listed twice.
  
  WHERE [Customer_ID]=1 AND [Master_ID]=1809 AND (Customer_ID = 1)

  bsimmons4 August 13, 2014 14:55

  - 0 +
• 
  Hello,
  
  Thanks for the update. You are correct in that the update will work and the query does look a bit incorrect with the customer ID listed twice. We have this logged as a bug under SDC-1087 to look at for future versions. It should not prevent the deployment script from executing. Sorry about the inconvenience.
  
  Best Regards,
  Steve

  stanori August 13, 2014 15:57

  - 0 +
• 
  In SDC 10, I have a where clause on my table to filter on data for 1 specific customer. When the UPDATE statement is created, I have an extra WHERE clause appended to the end of the statement.

  shahjee1 September 30, 2014 01:18

  - 0 +

Add comment

Please sign in to leave a comment.