InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.