[ic] Creating a Unique Primary Key
Wed, 29 Nov 2000 13:29:26 -0700 (MST)
Data Session ID's are repeated. They are recycled as sessions are expired... So
it is possible that once a week, month, or year you will have the same session
ID. Or at least that is my understanding...
Quoting Houman Akhavan <email@example.com>:
> That's what i'll do.
> Houman A.
> ----- Original Message -----
> From: "Mike Heins" <firstname.lastname@example.org>
> To: <email@example.com>
> Sent: Wednesday, November 29, 2000 11:56 AM
> Subject: Re: [ic] Creating a Unique Primary Key
> > Quoting Marcel Montes (firstname.lastname@example.org):
> > > Houman... your text is a little confusing but here's what I think I
> > >
> > > Houman Akhavan wrote:
> > >
> > > > I am running IC 4.6, MySQL Backend.
> > > >
> > > > I have created a table and a IC form that collects user input and
> stores it
> > > > in a MySQL table. Everytime someone fills out a form I need to
> > > > primary key to properly input the form data into the table. I
> > >
> > > On MySQL there's ONLY one primary key by table and as far as I know
> > > to be defined at table creation time. (for the primary index, not
> > > indexes).
> > If you want something database-independent, then you can just do:
> > [seti the_key][counter][/seti]
> > Then reference the number in the form as:
> > [scratch the_key]
> > (In earlier mvends, that would be [fcounter], usually in there
> > That will of course cause you to have non-sequential keys when people
> > enter the form but don't submit, but that shouldn't be any problem. As
> > long as you don't remove etc/counter, you won't have any problem.
> > --
> > Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
> > phone +1.513.523.7621 fax 7501 <email@example.com>
> > Any man who is under 30, and is not liberal, has not heart; and any
> > who is over 30, and is not a conservative, has not brains.
> > -- Winston Churchill
> > _______________________________________________
> > Interchange-users mailing list
> > Interchangefirstname.lastname@example.org
> > http://www.minivend.com/mailman/listinfo/interchange-users
> Interchange-users mailing list
P.A.L.B. Systems - Phone: (780)451-1086 - Fax: (780)447-4760
11639-122 Street, Edmonton, Alberta, Canada, T5M 0B6