🚀 go-pugleaf

U�ytkownik "Gelein van de Voorde" <gelein@gvsnet.nl> napisa� w wiadomo�ci 
news:464b69ad$1@newsgroups.borland.com...
> Karol Bieniaszewski wrote:
>
>> Hi Gelein.
>>
>> I test script with "commit" statement.
>>
>> Create table X1 ...
>> commit;
>> create second table X2
>> add foreign key from table X2 to X1
>>
>> run script
>>
>> it not work becaouse commit realy not commit transaction
>> and i get table X1 is in use error.
>>
>> When i do the same in IBConsole 7.5.0.1 it work ok.
>> Karol Bieniaszewski
>
> Karol,
> If you are using 8.0.0.50 please check the transaction options if the
> Access mode is "Write".
>

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