Myriam
The problem here's with ScriptTool rather than InstantDB. In the second
insert there's a comma in the string being inserted. ScriptTool isn't very
smart about parsing the contents of the "s" command and always treats a
comma as a delimiter - so it thinks you're trying to supply 5 parameters.
The easiest solution would be to perform an explicit INSERT rather than use
the prepared statement for inserts which require a comma in a string. If you
have a lot of inserts to perform then you might want to look at the
ScriptTool.java code to make it a bit smarter.
Regards
Peter Hearty
Lutris Technologies (UK)
----- Original Message -----
From: "Myriam Abramson" <abramson@nlm.nih.gov>
To: <instantdb@enhydra.org>
Sent: Monday, August 28, 2000 5:59 PM
Subject: InstantDB: inserting data
> s E0021903, 082400, derivation, {base=derivation
> entry=E0021903
> cat=noun
> variants=reg
> variants=uncount
> compl=(np,of)
> };
-----------------------------------------------------------------------------
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.
|