Book a Demo

Author Topic: DDL Template Editor - Lists of valid macros ...etc  (Read 3264 times)

Bryan Donohue

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
DDL Template Editor - Lists of valid macros ...etc
« on: April 30, 2015, 12:41:54 am »
Hello,
I have been playing around with DDL Template Editor in EA (V. 12.0.01211), and specifically looking at the DDL for Oracle, 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...

TEMPLATE: DDL Name, Lines 49 & 50:
   %elseIf $parameter2 == "CONSTRAINT"%
     $name=%[highlight]ddlConstraintName[/highlight]%
ddlConstraintName is clearly the Name of the Constraint (as viewed through Database Builder).  But what other properties can be displayed through macros?
<I will point out currently, I am looking for the condition info from Constraint window (lower/left hand pain).
I could not find any documentation (or search) that mentions Macros like ddlConstraintName... Where can I get these?

TEMPLATE: DDL Check Constraint
Line 15: (%[highlight]constraintProperty[/highlight]:"CHECKSTATEMENT"%)
In the above case, the command is pulling the value from constraintProperty for the property 'CHECKSTATEMENT'.  
How is this property created?  Where do I store this information?

Is there a guide or document somewhere that shows all possible values?

Thanks,
Bryan


Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: DDL Template Editor - Lists of valid macros ..
« Reply #1 on: April 30, 2015, 09:27:22 am »
I'm pretty sure the complete list is in the help. (I know it was complete before the ddl generation added additional macros) Try searching for one of the ones you have found.