Applying the rules of NamingConvention

Toad Data Modeler
1

Hi everybody,

We have developed a Macro to create an entity with several default attributes. This macro use a dialog box where the user enters some fields like caption and comments, …
So we want to apply the NamingConvention defined in model to get the name of the entity. This includes character conversion rules.

Is this possible?

Best regards,

Biel

2

Hi,

can you describe what rules should be used, please? I am not sure what you expect to receive. Naming conventions in TDM allows you to define physical names based on rules applied on logical names (captions). If you wish to use e.g. table name prefix, I recommend to add the prefix to attribute name in time of creation or develop another macro that will iterate attributes and add prefix to items where prefix is missing.

Please send me more information. Thank you.

Vaclav

3

Hi,

Thanks for your answer.

In the macro the users specify the logical table name (caption) and we would like that the physical table name was created with the rules of the naming convention applied (those that apply to table names).

I attach the naming convention used. Basically we add an “application prefix” to all table names and some special character conversions (Á --> A, È --> E, …).
Currently we’ve developed an acceptable workaround to resolve the “application prefix” issue, but we would like to achieve character conversions defined in naming convention.

Thanks!

Biel B.
INSACIFOR NAMING.txn (5.19 KB)

4

Hi,

if you create new objects by running your macro, I recommend to create new objects without prefixes and run Naming Convention Verification and Synchronization. See attached screenshot. Character replacement should work properly.

Regards,

Vaclav
nc-03.png

5

Thanks!

We consider this solution.

Regards,

Biel B.