Make your own free website on Tripod.com

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]

InstantDB: <no subject>


Hi everybody

Because of a project in our university, we are writing a Admin-GUI for INSTANTDB in Java Swing, we have some questions about the alter statement.

We want to add a column to an existing table with a foreign key.
We use the statements:
ALTER TABLE tablename ADD columnname datatype
ALTER TABLE tablename ADD FOREIGN KEY (columname) REFERENCES tablename (columname)

No Sql Exception is thrown, but the Database does not create the foreign key. 
The Column is added successfull (but no foreign key).

Do we use the right statements?
We read in the list that the ALTER ADD FOREIGN KEY is not implemented, but the mail is dated on 13 September. Is this feature implemented in V3.25 which we are using.

Thank you for your help.

Greetings
Hoelli 

______________________________________________________________________________
Die Fachpresse ist sich einig: WEB.DE 20mal Testsieger! Kostenlos E-Mail, 
Fax, SMS, Verschlüsselung, POP3, WAP....testen Sie uns! http://freemail.web.de

-----------------------------------------------------------------------------
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.