i want to generate an alphnumeric value for the primary key "EntryId" for a webblog app I'm building. If not "BigJ1", how would you go about just generating an incremental numeric Id for EntryId?
On Tue, Nov 18, 2008 at 7:00 AM, KeidrickP <[EMAIL PROTECTED]> wrote: > > I agree with Stephen. What exactly are you trying to accomplish? > > On Tue, Nov 18, 2008 at 7:18 AM, Stephen Russell <[EMAIL PROTECTED]> > wrote: > > > > Please don't do this. An ID should be not only unique, but have NO > VALUE. > > You are imparting value as "BigJ" and that is very wrong. Appending the > # > > 1,2,3 does not make it correct. > > > > > > ......................... > > Stephen Russell - > > Senior Visual Studio Developer, DBA > > > > Memphis, TN > > 901.246-0159 > > > > > > > > -----Original Message----- > > From: [email protected] > > [mailto:[EMAIL PROTECTED] On Behalf Of BigJ > > Sent: Monday, November 17, 2008 10:51 PM > > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web > > Services,.NET Remoting > > Subject: [DotNetDevelopment] Auto-generating a primary key > > > > > > 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.4/1790 - Release Date: > 11/17/2008 > > 8:48 AM > > > > > > >
