First of all, the end result of this function is just a translation of
an integer into a more complicated string - so there's no value in it
- if you've got a unique integer in the first place, why not use it?
But in addition, it's a bunch of nonsense formatting in order to
generate a letter or letters (A-Z, then AA,BB..ZZ, then AAA,BBB,etc.),
plus a number that is just always 1000 greater than the original.
It's unique, but it doesn't seem to serve any purpose.
On Nov 18, 12:00 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> what u mean.
>
>
>
> On Wed, Nov 19, 2008 at 1:56 AM, Joe Enos <[EMAIL PROTECTED]> wrote:
>
> > You can't be serious...Why in the world would you want to do this?
>
> > On Nov 18, 11:48 am, makhaai <[EMAIL PROTECTED]> wrote:
> > > to generate uniquekey please try this, u can modify my code.want any
> > > description reply me
>
> > > private string getPrefix(int count)
> > > {
> > > string PrefixString = "A";
> > > Char[] PrefixArray =
> > > "ABCDEFGHIJKLMNOPQRSTUVWXYZ".ToCharArray();
> > > if (count > 0)
> > > {
> > > int maxcount = count / 1000;
> > > if ((maxcount >= 0) && (maxcount <= 25))
> > > {
> > > PrefixString = Convert.ToString(PrefixArray
> > > [maxcount]);
> > > }
> > > else if ((maxcount >= 26) && (maxcount <= 676))
> > > {
> > > int preCount = maxcount / 26;
> > > PrefixString = Convert.ToString(PrefixArray
> > > [preCount - 1]) + Convert.ToString(PrefixArray[preCount - 1]);
> > > }
> > > else if ((maxcount >= 677) && (maxcount <= 458329))
> > > {
> > > int preCount = maxcount / 677;
> > > PrefixString = Convert.ToString(PrefixArray
> > > [preCount - 1]) + Convert.ToString(PrefixArray[preCount - 1]) +
> > > Convert.ToString(PrefixArray[preCount - 1]);
> > > }
> > > PrefixString = PrefixString + (Convert.ToString(1000 +
> > > count));
> > > }
> > > return PrefixString;
> > > }
>
> > > On Nov 19, 1:40 am, "Stephen Russell" <[EMAIL PROTECTED]> wrote:
>
> > > > >--ok...so you're saying it would be better just to use the unique
> > timestamp
>
> > > > as my unique identifier?
>
> > > > No not at all! That is a sort component.
>
> > > > .........................
>
> > > > Stephen Russell -
>
> > > > Senior Visual Studio Developer, DBA
>
> > > > Memphis, TN
>
> > > > 901.246-0159
>
> > > > From: [email protected]
> > > > [mailto:[EMAIL PROTECTED] On Behalf Of Jon Liu
> > > > Sent: Tuesday, November 18, 2008 10:03 AM
> > > > To: [email protected]
> > > > Subject: [DotNetDevelopment] Re: Auto-generating a primary key
>
> > > > ok...so you're saying it would be better just to use the unique
> > timestamp as
> > > > my unique identifier?
>
> > > > On Tue, Nov 18, 2008 at 8:00 AM, Joe Enos <[EMAIL PROTECTED]> wrote:
>
> > > > If after all of this you still want to proceed, I'd suggest a two-
> > > > column primary key, with the userid being the first part, and a new
> > > > regular integer being the second part. You can store "lastentryid" or
> > > > "nextentryid" in an int column on the user table, then reference it
> > > > whenever you need to insert a record.
>
> > > > I don't think you can both access and increment this column from
> > > > inside a function, so I think you'd either need to have your entire
> > > > statement inside of a stored proc, or use two separate commands.
>
> > > > On Nov 17, 9:50 pm, BigJ <[EMAIL PROTECTED]> wrote:
>
> > > > > I see a formula section, but not sure how to go about it. I
> > basically
> > > > > have an primary key called "EntryId" and I want to consist of UserId
> > > > > +unique counter, so if UserId="BigJ", and it's my first entry, then
> > > > > EntryId="BigJ1" and the next entry would be BigJ2 etc....any insight
> > > > > as to how to accomplish this? I know there is a formula field and I
> > am
> > > > > looking into it, but any insight or simple examples are apreciated,
> > as
> > > > > I left my SQL book at home lol...Thanks...
>
> > > > No virus found in this incoming message.
> > > > Checked by AVG -http://www.avg.com
> > > > Version: 8.0.175 / Virus Database: 270.9.6/1797 - Release Date:
> > 11/18/2008
> > > > 11:23 AM
>
> --
> Raju.M
> Snr:Software Engineer
> 3kInfoTech
> [EMAIL PROTECTED]
> m +919995117011
> of +16783673348http://www.makhaai.blogspot.com
