Thank you for your help.
It is an existing table with existing data.
But it seems our problem was not revolving around that anyways, it was another
poorly written jsp and asp application that didn't even use auto increment it
used a table called sequence to store the latest id and then increment from
there, kinda odd...
The bald spots in my hair should grow back, right? argh!!
Nathan Cook
ncook@pcsedu.com
----- Original Message -----
From: "Richard S. Hall" <heavy@richardhall.net>
To: <instantDB@enhydra.org>
Sent: Monday, April 09, 2001 12:51 PM
Subject: Re: InstantDB: Auto Incrementing
> Nathan Cook wrote:
>
> > I have a table called course_enrollments with these fields:
> > ID,USER_ID,COURSE_ID,LAST_PAGE_ID,STUDENT_STATUS,TYPE,START_DATE,END_DATE,
and I
> > would like to make the ID field auto increment. I have tried multiple
methods
> > based on some mysql stuff that I know and some information that I was able
to
> > get off of this page:
> > http://instantdb.enhydra.org/software/documentation/idb3_26/syntax.html
> >
> > Nonetheless when I insert null values into the db they remain null, instead
of
> > auto incrementing.
>
> Here is where I found the documentation on how to auto-increment and it worked
fine
> for me, although I have decided to stop using InstantDB for the time being...
>
> http://instantdb.enhydra.org/software/documentation/idb3_26/types.html
>
> Here is an example:
>
> e.g. CREATE TABLE table1 (int1 int AUTO INCREMENT)
>
> -> richard
>
> -----------------------------------------------------------------------------
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|