I don't understand your question. A primary key should be a unique identifier for a record in your table. What info is your weblog app tracking?
On Tue, Nov 18, 2008 at 9:12 AM, Jon Liu <[EMAIL PROTECTED]> wrote: > 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 >> > >> > >> > > >
