Re: Creating and saving IDs - is there a theory?

In article <01bc3e01$6556ad80$6bcacbc7@lior>, "Lior Messinger" <messingr@netvision.net.il> writes: > Hi, > > We are designing a project where we need to create, save and then verify > huge amounts of IDs (or serial numbers), for inventory items. We need to do <SNIP> I would strongly suggest that you incorporate a check digit on your ID so that you can verify on data entry that a valid ID has been entered before you even touch the database. A Table of IDs in a database is recommended too. Having said that - a relational database such as Informix is the next logical step. Choice of database of course depends on your particular needs. As to the check digit - I would use a Modulus 11 check digit and formula's for these are available. If you can't find one, email and I will dig one out. ---------------------------------------------------------------------- David Paulo, InForm Group Ltd.,PO Box 1444, Wellington, New Zealand. Ph: +64 4 472 0996 Fax: +64 4 473 2407 Email: david@inform.co.nz = What would you do if you knew that you could not fail = ----------------------------------------------------------------------