[ic] Creating a Unique Primary Key

[John Beima]

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...

John Beima


Quoting Houman Akhavan <houman@edigitalweb.com>:

> That's what i'll do.
> 
> Thanks,
> Houman A.
> 
> ----- Original Message -----
> From: "Mike Heins" <mikeh@minivend.com>
> To: <interchange-users@minivend.com>
> Sent: Wednesday, November 29, 2000 11:56 AM
> Subject: Re: [ic] Creating a Unique Primary Key
> 
> 
> > Quoting Marcel Montes (marcel@multimake.com):
> > > Houman... your text is a little confusing but here's what I think I
> catch:
> > >
> > > 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
> create
> a
> > > > primary key to properly input the form data into the table. I
> tried
> the
> > >
> > > On MySQL there's ONLY one primary key by table and as far as I know
> this
> has
> > > to be defined at table creation time. (for the primary index, not
> other
> > > 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
> somewhere).
> >
> > 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 <heins@akopia.com>
> >
> > Any man who is under 30, and is not liberal, has not heart; and any
> man
> > who is over 30, and is not a conservative, has not brains.
> >  -- Winston Churchill
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@www.minivend.com
> > http://www.minivend.com/mailman/listinfo/interchange-users
> 
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
> 



John Beima
jbeima@palb.com

P.A.L.B. Systems - Phone: (780)451-1086 - Fax: (780)447-4760
11639-122 Street, Edmonton, Alberta, Canada, T5M 0B6