Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2010
    Posts
    39

    Unanswered: Server 2000 Automatic Number issue

    I have an application setup using sql server 2000 as database.

    In the application, I assign integer number to teams when administrator adds any team. But not the number of teams have become more than 999 and after that team number are being given (*) as their team number rather than a integer value.

    Why is this happening and how can i resolve this issue ?

    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Are you checking this in grid view? You may need to expand the column for the number to appear.

  3. #3
    Join Date
    Jul 2010
    Posts
    39
    but even if i am viewing the same team number in different location in a text box, there also it is printing * instead of incremented integer.

    Can it be stored in database itself with * instead of automatic integer

  4. #4
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Run
    SELECT * FROM YourTableNameGoesHere..
    on that table
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Unless the field is defined as a character field, there is either a number or a null in there. What is the field defined as?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •