Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: gjvandijk on October 02, 2018, 11:41:53 pm

Title: SQL query fails for field Constraint in table t_objectconstraint
Post by: gjvandijk on October 02, 2018, 11:41:53 pm

Hi,
I tried to create a sql query on the t_objectconstraint table with a selection on field Constraint.
On an eapx file this works fine, but when I tried to use it on a sql server repository de query fails with error:Incorrect syntax near the keyword 'Constraint'.

SQL Query(simplyfied):
Select t_objectconstraint.*
FROM t_objectconstraint
WHERE Constraint = 'SOURCETABLE'

So it appears to met that Constraint is a reserved word for SQL server databases.
Is there a workaround for this?

Title: Re: SQL query fails for field Constraint in table t_objectconstraint
Post by: Geert Bellekens on October 03, 2018, 01:59:38 am

Code: [Select]

Select t_objectconstraint.*
FROM t_objectconstraint
WHERE [Constraint] = 'SOURCETABLE'
Geert