[ic] Creating a Unique Primary Key

Joe Tarnow joe_punch_clock@yahoo.com
Wed, 29 Nov 2000 11:30:27 -0800 (PST)

--- Houman Akhavan <houman@edigitalweb.com> 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
> MySQL AUTO_INCREMENT function in the mysql data
> structure, and also
> specified it in the table.mysql file. But this was
> not working properly, So
> I figured it would be best to create a unique key in
> the form, right before
> inserting the row. Is there a way for me to check
> the previous record
> primary key value and add 1 to it? I remember
> reading it somewhere but I
> can't seem to find it.
[data session id]-plus an incremented number for each
time the form is filled out
is a goog start.

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.