Skip to main content
Completed

Validation on RDBMS reserved keywords

Related products:Software Factory

Jop ter Horst
Vanguard

I noticed there isn't a (complete) list of reserved keywords as a validation. A customer of mine had a upgrade go wrong because there was a domain with the name 'boolean’. Ofcourse that's not a good name, but the Software Factory didn't tell him in the validation, but only when the upgrade script went wrong.

 

I suggest that the list is expanded and depending on the selected RDBMS available as a validation.

Robert Jan de Nie
Thinkwise blogger
Forum|alt.badge.img+5

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9

Agreed. As @Kevin Horst said in another topic, most of the time new inexperienced Thinkwise developers try to create domains with a name the same as a pre-existing datatype on the database, like:

  • Int
  • Money
  • Date
  • Datetime
  • etc.

These don't show up in the validations. I've added this wish to our backlog.


Jasper
Superhero
  • March 24, 2020

We have expanded the list of reserved keywords that will be checked for the 2020.2 release. 

From the very long list of possible future keywords, which also contains the BOOLEAN keyword, we have made a limited selection, including the SQL server data types.



Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings