[ic] Creating a Unique Primary Key
Wed, 29 Nov 2000 14:56:01 -0500
Quoting Marcel Montes (firstname.lastname@example.org):
> 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
If you want something database-independent, then you can just do:
Then reference the number in the form as:
(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