Need help working from home with your Bentley software? We're here to help - click here

When I try to add an element to my model I get an error message that says, "1: near "Update": syntax error"

   
  Applies To 
   
  Product(s):
Bentley WaterGEMS, Bentley SewerGEMS, Bentley CivilStorm, Bentley StormCAD, Bentley PondPack, Bentley SewerCAD, Bentley HAMMER, Bentley WaterCAD
  Version(s): 08.11.XX.XX
  Environment:  N/A
  Area: 
  Original Author: Mark Pachlhofer, Bentley Technical Support Group
   

Problem

When I try to add an element to my model I get an error message that says, "1: near "Update": syntax error" and I can't continue. How do I fix this?

Solution

Delete any User Data Extension fields with the names of reserved SQL keywords such as,  "Insert", "Update", "Delete", "Where", "Like", etc and/or rename the fields with a slightly different name like "Update_1" or "_Delete_", etc...

Starting in Select Series 6 of the Water products and Select Series 5 of the Storm and Sewer products this will not be an issue.

 

  • Created by
  • When: Tue, Apr 14 2015 10:21 AM
  • Revisions: 1
  • Comments: 0
Recommended
Related