Re: [Emerald] customer ID Question (autonumber) BIG QUESTION!

Dale E. Reed Jr. ( (no email) )
Fri, 03 Mar 2000 14:33:28 -0800

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Nathan Haywood: "RE: [Emerald] customer ID Question (autonumber) BIG QUESTION!"
Next message: Howard A. Brooks: "Re: [Emerald] Balance Forward"
Maybe in reply to: Kenneth Jaeger: "[Emerald] customer ID Question (autonumber) BIG QUESTION!"

> Kenneth Jaeger wrote:
>
> I was just looking at the Database schema that came with emerald 2.5
> and noticed that the customerID is an integer autonumber. What is the
> max number that this field can support? (I think 32,768) what
> happens after that number is reached?

If you check your SQL Server docs, you'll see that an int in SQL
is 32-bit. Therefores its 2^31 (-1 for signed), or about 2 billion,
give or take a couple million.

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart

Previous message: Nathan Haywood: "RE: [Emerald] customer ID Question (autonumber) BIG QUESTION!"
Next message: Howard A. Brooks: "Re: [Emerald] Balance Forward"
Maybe in reply to: Kenneth Jaeger: "[Emerald] customer ID Question (autonumber) BIG QUESTION!"