[ic] Creating a Unique Primary Key

[Houman Akhavan]

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