# Applying the rules of NamingConvention

**URL:** <https://forums.toadworld.com/t/applying-the-rules-of-namingconvention/2620>\
**Category:** Toad Data Modeler\
**Created:** [January 12, 2012, 4:14am UTC](https://forums.toadworld.com/t/applying-the-rules-of-namingconvention/2620 "2012-01-12T04:14:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![desarrollo\_687](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/desarrollo_687/32/59_2.png) [@desarrollo\_687](https://forums.toadworld.com/u/desarrollo_687)\
**Post date:** [January 12, 2012, 4:14am UTC](https://forums.toadworld.com/t/applying-the-rules-of-namingconvention/2620/1 "2012-01-12T04:14:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Vaclav\_Frolik](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vaclav_frolik/32/12_2.png) [@Vaclav\_Frolik](https://forums.toadworld.com/u/Vaclav_Frolik)\
**Post date:** [January 12, 2012, 6:07am UTC](https://forums.toadworld.com/t/applying-the-rules-of-namingconvention/2620/2 "2012-01-12T06:07:06Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![desarrollo\_687](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/desarrollo_687/32/59_2.png) [@desarrollo\_687](https://forums.toadworld.com/u/desarrollo_687)\
**Post date:** [January 16, 2012, 11:28am UTC](https://forums.toadworld.com/t/applying-the-rules-of-namingconvention/2620/3 "2012-01-16T11:28:02Z")

</div>

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](https://global.discourse-cdn.com/quest/original/2X/0/083e94740899b65ff2be015b78adc1eb0fb30452.txn) (5.19 KB)

---

<div class="post-metadata">

**Author:** ![Vaclav\_Frolik](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vaclav_frolik/32/12_2.png) [@Vaclav\_Frolik](https://forums.toadworld.com/u/Vaclav_Frolik)\
**Post date:** [January 17, 2012, 6:29am UTC](https://forums.toadworld.com/t/applying-the-rules-of-namingconvention/2620/4 "2012-01-17T06:29:02Z")

</div>

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](https://global.discourse-cdn.com/quest/original/2X/2/266e4ed3b9024126d15af8e87579e8d9c2b1fc0a.png)

---

<div class="post-metadata">

**Author:** ![desarrollo\_687](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/desarrollo_687/32/59_2.png) [@desarrollo\_687](https://forums.toadworld.com/u/desarrollo_687)\
**Post date:** [January 17, 2012, 8:40am UTC](https://forums.toadworld.com/t/applying-the-rules-of-namingconvention/2620/5 "2012-01-17T08:40:08Z")

</div>

Thanks!

We consider this solution.

Regards,

Biel B.