Book a Demo

Author Topic: DDL for SQL Server  (Read 3471 times)

Martin P.

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
DDL for SQL Server
« on: March 03, 2020, 05:47:16 pm »
Hello EA experts!
I have been playing around with DDL Template Editor in EA (V. 15), and specifically looking at the DDL for SQL Server, but I think this is a broader question/inquiry...
It is really nice how the editor signifies keywords, such as Macros, options... etc.
I also like how if you hover the mouse over the word, it will give you a little description...
My issue is, Where can I get a full list of all possible valid 'keywords'. 
My biggest concern is the field reference macros, as I am trying to display certain things in my script.
Let me give you a couple of examples...
First, please note these come from the default DDL Templates...
Thank you very much!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: DDL for SQL Server
« Reply #1 on: March 03, 2020, 05:57:53 pm »
I'm pretty sure they should all be in the help somewhere.

I just don't know where exactly. :-\

Geert

Martin P.

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: DDL for SQL Server
« Reply #2 on: March 03, 2020, 11:02:44 pm »
Thanks for the quick reply.
There are some good information in the help/documentation about the arguments for DDL Macros (see https://sparxsystems.com/enterprise_architect_user_guide/14.0/model_domains/ddl_function_macros.html).
However, there is no description for arguments of DDL Property Macros. Description of all of these arguments is always:
“propertyName - the property name that is to be retrieved” (see https://sparxsystems.com/enterprise_architect_user_guide/14.0/model_domains/ddl_property_macros.html)
I cannot find any information about available “propertyName”s that can be retrieved anywhere.
Can you please provide some pointers?
Thanks a lot!

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1297
  • Karma: +21/-4
  • Read The Help!
    • View Profile
Re: DDL for SQL Server
« Reply #3 on: March 05, 2020, 10:44:31 am »
I am no expert in this area, but the properties are Tagged Values, so you give the macro the Tag name and it returns the value. Does that make sense?
Best Regards, Roy