Click here to Skip to main content
16,006,382 members
Home / Discussions / C#
   

C#

 
GeneralMemory Error Pin
dbetting28-Aug-04 4:32
dbetting28-Aug-04 4:32 
GeneralRe: Memory Error Pin
dbetting28-Aug-04 10:17
dbetting28-Aug-04 10:17 
GeneralTo change an int or float to text Pin
TehGT28-Aug-04 4:09
TehGT28-Aug-04 4:09 
GeneralRe: To change an int or float to text Pin
Mazdak28-Aug-04 4:44
Mazdak28-Aug-04 4:44 
GeneralDataGrid control Pin
sasan5628-Aug-04 3:43
sasan5628-Aug-04 3:43 
GeneralRe: DataGrid control Pin
Mazdak28-Aug-04 4:42
Mazdak28-Aug-04 4:42 
GeneralDatabases Autonumber mechanism Pin
EDden2Fly28-Aug-04 2:49
sussEDden2Fly28-Aug-04 2:49 
GeneralRe: Databases Autonumber mechanism Pin
Marc Clifton28-Aug-04 16:20
mvaMarc Clifton28-Aug-04 16:20 
EDden2Fly wrote:
I wana know what happens when this number reachs its maximum value, and whats the approach in this case?

Erm...this number is so big that you'd run out of disk space just to hold all the records way before you'd reach the max value, I would imagine.

If you use the decimal type with maximum precision, that's 10^38 unique identities! "bigint" is 9,223,372,036,854,775,807.

OK, if you use int (2Gb), smallint (32K), or tinyint (255), then yes, you'd have a problem.

So, what happens when you set an identity to a tinyint type and add the 256'th record?

Marc

Microsoft MVP, Visual C#
MyXaml
MyXaml Blog
Hunt The Wumpus
RealDevs.Net
GeneralRe: Databases Autonumber mechanism Pin
Den2Fly29-Aug-04 22:49
Den2Fly29-Aug-04 22:49 
GeneralMDB question Pin
jzb27-Aug-04 23:32
jzb27-Aug-04 23:32 
GeneralRe: MDB question Pin
mav.northwind28-Aug-04 0:03
mav.northwind28-Aug-04 0:03 
GeneralRe: MDB question Pin
dbetting28-Aug-04 4:28
dbetting28-Aug-04 4:28 
GeneralRe: MDB question Pin
Marc Clifton28-Aug-04 16:22
mvaMarc Clifton28-Aug-04 16:22 
Generalusing Alpha Color - Mouse Rectangle rendered Pin
CRier27-Aug-04 22:10
CRier27-Aug-04 22:10 
GeneralRe: using Alpha Color - Mouse Rectangle rendered Pin
mav.northwind27-Aug-04 22:29
mav.northwind27-Aug-04 22:29 
GeneralRe: using Alpha Color - Mouse Rectangle rendered Pin
CRier27-Aug-04 23:00
CRier27-Aug-04 23:00 
GeneralRe: using Alpha Color - Mouse Rectangle rendered Pin
mav.northwind27-Aug-04 23:48
mav.northwind27-Aug-04 23:48 
GeneralDrawing text via "DrawThemeText" Problem Pin
Tristan Rhodes27-Aug-04 19:45
Tristan Rhodes27-Aug-04 19:45 
GeneralSave Pin
WartHog00027-Aug-04 15:13
WartHog00027-Aug-04 15:13 
GeneralRe: Save Pin
Heath Stewart27-Aug-04 15:26
protectorHeath Stewart27-Aug-04 15:26 
GeneralRe: Save Pin
WartHog00027-Aug-04 15:37
WartHog00027-Aug-04 15:37 
GeneralRe: Save Pin
dbetting28-Aug-04 10:35
dbetting28-Aug-04 10:35 
GeneralRe: Save Pin
WartHog00029-Aug-04 13:25
WartHog00029-Aug-04 13:25 
GeneralCursor position in a Combobox Pin
StephenMcAllister27-Aug-04 9:45
StephenMcAllister27-Aug-04 9:45 
GeneralRe: Cursor position in a Combobox Pin
Heath Stewart27-Aug-04 10:05
protectorHeath Stewart27-Aug-04 10:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.