[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [ic] Creating a Unique Primary Key
--- 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.
http://shopping.yahoo.com/
_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users
