Web Wiz Forums - MSSQL identity field for unique ID numbers

Print Page | Close Window

MSSQL identity field for unique ID numbers

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22064
Printed Date: 08 April 2026 at 1:53pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MSSQL identity field for unique ID numbers

Posted By: bikeweb
Subject: MSSQL identity field for unique ID numbers
Date Posted: 29 November 2006 at 8:09pm

I'm posting this question again since nobody anwered the question the last time I posted it but I'll try and rephrase the question.

With a MSSQL database, to assign a unique ID number to a field item. WWF uses the "int" Type with a length of 4, the nullable column is unchecked, the Id column is checked, start and Id seed are set to to 1,1.

I have several fields in my own database that use this same method.

My question is this:

Because the length is 4 does this mean that the total entries can only be up to 9999? What if I have a database with more than 10,000 entries in this field? Is the WWF limited to this many entries?

I'm worried about using this method and also using WWF for my project if this is the case.

I've already purchased a license.

Thanks

Replies:

Posted By: michael
Date Posted: 29 November 2006 at 10:49pm

INT's are stored in binary and not as a string, so 4 is enough. INT can hold anything between -2^31 (-2,147,483,648) through 2^31 -
1 (2,147,483,647) that should give you enough room for now.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: bikeweb
Date Posted: 29 November 2006 at 10:56pm

Thanks for the follow up. I tried to google the answer myself and I wasn't getting anywhere. I knew that the fields couldn't be that limited.