Re: commit statement not work

Article View: borland.public.interbase.ibconsole

Article #141

Back to borland.public.interbase.ibconsole Previous Next

#141

From: Gelein van de Voorde
Date: Fri, 18 May 2007 19:26

26 lines
1461 bytes

> try this - copy all to SQL window:
> 
> CREATE TABLE XXX
> (
> ID INTEGER NOT NULL PRIMARY KEY
> );
> 
> commit;
> CREATE TABLE YYY
> (
> ID Integer NOT NULL primary key,
> ID_XXX INTEGER
> );
> 
> ALTER TABLE YYY ADD FOREIGN KEY (ID_XXX) REFERENCES XXX(ID) ON DELETE
> NO ACTION ON UPDATE CASCADE;
> 
> and run whole script
> you get object XXX is in use
> try the same in IBConsole 7.5.0.1
> 
> Karol Bieniaszewski
Karol,
I can not reproduce this. Do you have nowait enabled?
If so, do you have journaling enabled?
Are you testing against a local or remote database?

Technical Details

Message-ID: <464dfdd6@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news2.arglkargh.de!noris.net!news.osn.de!diablo1.news.osn.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <464ac764@newsgroups.borland.com> <464b69ad$1@newsgroups.borland.com> <464c01ae$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: f4565,48b8665fdcbfdfee
X-Google-Attributes: gidf4565,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Gelein van de Voorde" <gelein@gvsnet.nl>
Subject: Re: commit statement not work
Newsgroups: borland.public.interbase.ibconsole
References: <464ac764@newsgroups.borland.com> <464b69ad$1@newsgroups.borland.com> <464c01ae$1@newsgroups.borland.com>
User-Agent: XanaNews/1.18.1.6
NNTP-Posting-Host: 82.173.185.201
Message-ID: <464dfdd6@newsgroups.borland.com>
Date: 18 May 2007 12:26:14 -0700
X-Trace: newsgroups.borland.com 1179516374 82.173.185.201 (18 May 2007 12:26:14 -0700)
Lines: 26
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news2.arglkargh.de!noris.net!news.osn.de!diablo1.news.osn.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message