Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread FK problem
Fri, Feb 2 2007 4:07 PMPermanent Link

"Ole Willy Tuv"
1)

create table test
(
 c1 integer not null,
 c2 integer,
 constraint pk_test primary key (c1),
 constraint fk_test_c2
   foreign key (c2)
   references test (c1)
)

Error:
ElevateDB Error #401 The table test does not exist

2)

create table test
(
 c1 integer not null,
 c2 integer,
 constraint pk_test primary key (c1)
)

alter table test
add constraint fk_test_c2
 foreign key (c2)
 references test (c1)

Error:
ElevateDB Error #300 Cannot lock table test for exclusive access

Ole Willy Tuv

Fri, Feb 2 2007 5:33 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ole,

I was wondering how long it would take before you would notice this. Smiley
I've known about it for some time and have had it on the list of items to
address, and I actually fixed these issue last Tuesday.  Build 7 will have
the fixes.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image