AutoCAD Plant 3D General DIscussion

AutoCAD Plant 3D General DIscussion

Reply
Valued Contributor
56 Posts
3 Kudos
Registered: ‎07-12-2011
Post 1 of 2
Accepted Solution

PnID Format expression string length

670 Views, 1 Replies
01-03-2013 05:41 AM

Hello, i keep getting a notification "The format expression string cannot be longer than 255 characters" when i try to save a Tag Format Setup in Autocad PnID. See attached picture.

When i count the characters in the tag format setup it is far below 255 characters. Does anyone know which other characters is have to count?

 

Regards,

Jan Harink

Hi Jan,

 

The length of 255 is a limitation of SQL which will be used here in the background. The subparts and the delimiters will be internally concatenated with the concatenation symbol (||). The delimiters will be set in "" because they are strings, for example "-". If you leave for one subpart the delimiter blank, it will be translated to "". I have translated your tag format to a SQL expression. This expression I have attached here as a snapshot. Look for the count of the signs used (blanks will be counted, too) and it is about 271 signs. So it is higher than 255 signs and you will get the message.

 

Please, inform me if I could help you here.

 

Regards

Bernd

Product Support
172 Posts
16 Kudos
Registered: ‎09-20-2010
Post 2 of 2

Re: PnID Format expression string length

01-08-2013 04:53 AM in reply to: Jan-TSpD

Hi Jan,

 

The length of 255 is a limitation of SQL which will be used here in the background. The subparts and the delimiters will be internally concatenated with the concatenation symbol (||). The delimiters will be set in "" because they are strings, for example "-". If you leave for one subpart the delimiter blank, it will be translated to "". I have translated your tag format to a SQL expression. This expression I have attached here as a snapshot. Look for the count of the signs used (blanks will be counted, too) and it is about 271 signs. So it is higher than 255 signs and you will get the message.

 

Please, inform me if I could help you here.

 

Regards

Bernd



Bernd Gerstenberger
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Plant 3D Category!

The AutoCAD Plant 3D forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.