Modify the ID of label_defintions?

[Peter2_1]

Oracle, Industry Model

Situation (as usual):

I have a Wastewater-Industry Model "City A" with label_definitons and a style definition (display model), simplified like this:

• when label_def_id = 1 (name), then display the text red
• when label_def_id = 2 (age), then display the text green

Now I want to use the same style definition (display model) for a similar industry model "City B", but there are other IDs used:

• label_def_id 1 is not used
• label_def_id 2 is used for "name"
• label_def_id 12 is used for "size"

Is it possible and "allowed" that I modify the IDs in "City B" to be the same as in "City A"?

[swt-gis]

I do not think there is a simple solution to change label_def_id.

label_def_id stored in table TB_LABEL_DEF in field ID.

http://help.autodesk.com/view/MAP/2020/ENU/?guid=GUID-E3969EAD-73FB-482F-9A21-1A83F0CD78DB

You can't just change ID in this table. It is based on a sequence tb_labeldef_s.

(also interesting about tb_labeldef_s: http://raumpatrouille3d.blogspot.com/2013/11/tblabeldefid.html )

I'm not saying it is not possible to change the ID, but there are certainly things to consider. I would have great doubts doing this.

I have not tried it, but maybe this approach would be possible:

Do not use TBL-table in display modell.

Use a view (based on TBL-table) instead. (up to here I can say that it works; we often do that).

The view is based on TBL-table and additionally contains field NAME from table TB_LABEL_DEF.

In display model query field NAME of the view.

Regards

Jens

[Peter2_1]

Hi Jens

thanks for your detailed information. In the meantime I started a support-case; let's see if there will be ways to go without problems. I will report ..

[Peter2_1 · Accepted solution]

A solution, completely new documented here:

https://knowledge.autodesk.com/de/support/autocad-map-3d/troubleshooting/caas/sfdcarticles/sfdcartic...

[Peter2_1]

Did someone make already some experience with this solution to report it here?

[Peter2_1]

---

@swt-gis  schrieb:

I do not think there is a simple solution to change label_def_id.

label_def_id stored in table TB_LABEL_DEF in field ID.

http://help.autodesk.com/view/MAP/2020/ENU/?guid=GUID-E3969EAD-73FB-482F-9A21-1A83F0CD78DB

You can't just change ID in this table. It is based on a sequence tb_labeldef_s.

(also interesting about tb_labeldef_s: http://raumpatrouille3d.blogspot.com/2013/11/tblabeldefid.html ) ....

I want to reactivate these details again.

In my test-scheme I did 2 things relating for pipes

• changed via SQL dev. in table "label_def_id" one ID from 10011 to 20011
• deleted def. 10007 in AIA

What happened:

• nothing (bad)
  • 1-Klick-Wartung shows nothing
  • "refresh all labels" from AIA created no error
  • the modification of the pipe did change the unchanged labels, but labels based on 10011 and 10007 stayed unchanged. There where no error message
• then I changed the "10011-labels" to be based on 20011 - and content is refreshed as expected ...

So anyone here who can confirm it?

Have a great weekend!