Aras Community

Welcome to Aras Community Sign in | Join | Help
in Search
Aras Community
Please Also Visit the Project Site to Download Add-Ons and Solutions
Jump to Projects

about Sequence format??

Last post 09-05-2008, 3:18 AM by SamsAn. 1 replies.
Sort Posts: Previous Next
  •  09-04-2008, 11:31 PM 1047

    about Sequence format??

    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:
  •  09-05-2008, 3:18 AM 1048 in reply to 1047

    Re: about Sequence format??

    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.
     

View as RSS news feed in XML
Powered by Community Server, by Telligent Systems