[ic] Creating a Unique Primary Key
Wed, 29 Nov 2000 11:59:22 -0800
That's what i'll do.
----- Original Message -----
From: "Mike Heins" <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
> > > in a MySQL table. Everytime someone fills out a form I need to create
> > > primary key to properly input the form data into the table. I tried
> > On MySQL there's ONLY one primary key by table and as far as I know this
> > 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 <email@example.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