Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Change order numbering

  1. 03-04-2011, 06:26 AM #1
    knuttall is offline Junior Member
    Join Date
    Feb 2011
    Posts
    7

    Default Change order numbering

    I am trying to change the order numbering to start with a "W" for example order number W810000. I have entered the code "dbcc checkident(OrderNumbers, reseed, W810000)" into the Run SQL Command page as the manual says to do. It gave me this error message back.

    ERROR: Exception=Parameter 3 is incorrect for this DBCC statement.

    Can someone please help. This has to be changed in order for our ordering database to work correctly.

    Thanks
  2. 03-04-2011, 11:57 AM #2
    chrismartz is offline Senior Member
    Join Date
    Apr 2010
    Posts
    339

    Default

    You will not be able to do this easily. As it is, Order Number is an int in the database. There are many tables that reference this and would need to be modified. A major re-write of the software would need to be done to allow letters in the order number.
    Chris Martz
    United Art & Education