Thanks for reporting this. I too am having problems reproducing this.
When you talk of SQL with parameter lists, do you mean
PreparedStatements? I tried them out as well. You can script these also
p UPDATE Parent SET NAME = ?, STUFF = ? WHERE NAME = ?;
Is there any more info you can give on this problem?
You also sent an earlier email suggesting that sensible default formats
be adopted for TIMESTAMP and equivalent types. I think that's a good
idea and I'll put it in a future release.
Peter Hearty firstname.lastname@example.org
Lutris Technologies (UK) http://www.lutris.com/
----- Original Message -----
From: Suchko Paul M <email@example.com>
Date: Wednesday, November 29, 2000 8:31 pm
Subject: Updating of parent table using param list fails
> When a non-key columns of parent tables participating in
> integrity are updated using SQL with parameter list (i.e., ?, ? ,
> ?), the
> updates are failing with the following message.
> "Cannot delete value, 123. In use by column Child.ID"
> I tried build a test script to do this but I could not
> reproduce it
> which makes me think it has to do with parameters list processing
> which I
> cannot use in scripts.
> d org.enhydra.instantdb.jdbc.idbDriver;
> o jdbc:idb:C:\IBMVJava\IDE\project_resources\IBM WebSphere Test
> e DROP TABLE Child;
> e DROP TABLE Parent;
> e CREATE TABLE Parent (
> ID INTEGER PRIMARY KEY UNIQUE NOT NULL AUTO INCREMENT,
> NAME CHAR(40) UNIQUE,
> STUFF CHAR(40)
> e CREATE TABLE Child (
> ID INTEGER PRIMARY KEY NOT NULL,
> STUFF CHAR(40)
> FOREIGN KEY(ID) REFERENCES Parent(ID) ON DELETE CASCADE;
> e INSERT INTO Parent(NAME) VALUES("FOO");
> e INSERT INTO Child(ID, STUFF) VALUES(1000, "stuff");
> e INSERT INTO Child(ID, STUFF) VALUES(1000, "stuff1");
> e INSERT INTO Child(ID, STUFF) VALUES(1000, "stuff2");
> e INSERT INTO Child(ID, STUFF) VALUES(1000, "stuff3");
> e UPDATE Parent SET NAME = "BAR", STUFF = "HIYA" WHERE NAME =
> c close;
> > Paul M. Suchko
> > GTS Technology
> > Phone: (412) 234-2075
> > Fax: (412) 236-2032
> DISCLAIMER: The information contained in this e-mail may be
> confidentialand is intended solely for the use of the named
> addressee. Access, copying
> or re-use of the e-mail or any information contained therein by
> any other
> person is not authorized. If you are not the intended recipient
> pleasenotify us immediately by returning e-mail to the originator.
To unsubscribe from this mailing list, send email to firstname.lastname@example.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 email@example.com.