Hi guys,


I have an multiuser application that generates id numbers randomly but I would like to have SQL 2000 to generate those numbers using an Identity field and this is my question:

How do I read the identity value upon creation time...?

that way I don't have to generate numbers from the program and have the program check the database to see if that number already exists and if it does repeat the process again..to me that is a waste of time and too many trips to the database with multiple users.

Thanks.

=======================
Strange and crazy, but everything is possible

__________________
=======================
Strange and crazy, but everything is possible

And what if two clients create the same number and then try to insert a new record at the same time with that number?

You should rely on SQL to take care of this, or look at the uniqueidentifier data type which is also unique, but allows you to create an ID up front (a GUID) using code.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: My List by The Killers (Track 9 from the album: Sam's Town) What's This?

Thanks for the quick response. I have never used a GUID, my application is writen in VB6, so far the program check the table for that generated number if exists try to generate another one and checks the table again. I know it sounds redundant, how do I create a GUID using VB6. I will do a research but for the mean time can you point me to an example?

Thank you.

=======================
Strange and crazy, but everything is possible

You need to do some old skool API calls....

http://www.devx.com/vb2themax/Tip/18261


Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Why Do I Keep Counting by The Killers (Track 11 from the album: Sam's Town) What's This?

Don't use a GUID... world of pain...

Use an IDENTITY column and then use the SCOPE_IDENTITY function to get the ID it generated... Lookup SCOPE_IDENTITY in Books Online (comes free with SQL) for examples on how to use.

--Jeff Moden