Alok,
This seems to happen when a tab character immmediately follows the
preceeding semicolon.
David
-----Original Message-----
From: martin.husted@notes.electrolux.dk
[mailto:martin.husted@notes.electrolux.dk]
Sent: 17 May 2000 08:20
To: instantDB@enhydra.org
Subject: Re: InstantDB: Expected: "UNIQUE" found: ";"
Hey Alok,
I have just made the table "GroupMember" by taking a copy/paste in your mail
into one of my testprograms. Don't know if
it matters, but try writing statement in one line.
Martin
Alok Daipuria <alok@yack.com> on 17-05-2000 00:23:58
Please respond to instantDB@enhydra.org
To: instantdb@enhydra.org
cc:
Subject: InstantDB: Expected: "UNIQUE" found: ";"
I am trying to create tables thru my own sql1.txt containing :
--------- sql1.txt ------
d jdbc.idbDriver;
o jdbc:idb=/home/tech/alok/DB/db.prp;
e CREATE TABLE GroupMember (
GroupId CHAR(20) PRIMARY KEY,
UserId CHAR(20) PRIMARY KEY,
GroupRole CHAR(10) );
c close;
-------- sql1.txt ends----
I run "sample" program on this and I get the following error
(cut-pasting from trace.log) :
sql1.txt CREATE TABLE GroupMember ( GroupId CHAR(20) PRIMARY KEY,
UserId CHAR(20) PRIMARY KEY, GroupRole CHAR(10) ); c close
Don't understand SQL after: ";"
Expected: "UNIQUE" found: ";"
Any clues as to what it might be? Actually I tried creating 20 tables
but it created only one (the last one in list) & gave the above errors
for the rest.
I tried creating the above table thru commsql and it worked.
-alok
----------------------------------------------------------------------------
-
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.
-----------------------------------------------------------------------------
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.
|