about Sequence format??

rated by 0 users
This post has 1 Reply | 1 Follower

Top 500 Contributor
Posts 4
Points 0
Reply
miffy Posted: Thu, Sep 4 2008 11:31 PM

I want to change the formate of Project Number in the Sequence
original formate is only have Current Value setting
I want to add the Prefix ex:TX , but when i create a project then save it
the error message display :ProcessProjectTree:MethodMainSubroutine:The
Property proj_num should contain a integer value. pattern check fro integer failed.

I try to change the type of project_number to nvarchar in
SQL but still can not change that, could you tell me why?? thanks!!

 

  • Filed under:
  • | Post Points: 0
Top 10 Contributor
Posts 178
Points 1,240
Reply
SamsAn replied on Fri, Sep 5 2008 3:18 AM

First, i don't recommend to modify Innovator db tables column types through SQL.

To have the behavior you should:
1. Edit Project ItemType, set data_type=string, stored_length=16 for project_number property (see Properties tab).
2. Edit Activity2 ItemType, set data_type=string, stored_length=16 for proj_num property.
3. Edit Wbs Element ItemType, set data_type=string, stored_length=16 for proj_num property.

Hope it helps.
 

  • | Post Points: 0
Page 1 of 1 (2 items) | RSS