Right, primary key values are unique. So what I am saying is I want to auto generate the Id like a counter. Example, when I insert an entry, I'd like it to generate EntryId=1, then on the next insertion, EntryId=2, then EntryId=3 so on and so forth...
On Tue, Nov 18, 2008 at 7:19 AM, KeidrickP <[EMAIL PROTECTED]> wrote: > > 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 > >> > > >> > > >> > > > > > >
