commit statement not work

Article View: borland.public.interbase.ibconsole

Article #228

Back to borland.public.interbase.ibconsole Previous Next

#228

From: Karol Bieniaszewski
Date: Wed, 16 May 2007 09:01

16 lines
1245 bytes

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

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f4565,48b8665fdcbfdfee,start
X-Google-Attributes: gidf4565,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Karol Bieniaszewski" <liviuslivius@poczta.onet.pl>
Newsgroups: borland.public.interbase.ibconsole
Subject: commit statement not work
Date: Wed, 16 May 2007 11:01:35 +0200
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 195.205.151.58
Message-ID: <464ac764@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1179305828 195.205.151.58 (16 May 2007 01:57:08 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail