New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
object "TABLENAME" is in use [CORE998] #1409
Comments
Commented by: @hvlad Can't reproduce with isql and both AUTODDL ON and OFF |
Commented by: @dyemanov What tool was used to run the script? |
Commented by: Baldur F?rchau (fuerchau) I have the same Problem now: Firebird 2.0.0.12748 The following Code produce this error allways, it does no matter, which tool i use (VB6 SP6, Excel97 VB-Macro) Option Explicit Private Const DBName = "D:\Downloads\FTKENNZAHLEN.FDB" Public Sub TestFB()
End Sub Error-Message: Errorcode: Hex 8004D016 Errorsource: Microsoft OLE DB Provider for ODBC Drivers If i close the connection and open new, than i can drop the table. |
Modified by: @pcisarWorkflow: jira [ 11314 ] => Firebird [ 15394 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Daniel Cola?o (lightyearsaway)
I've downloaded and installed Firebird-2.0.0.12748-0-Win32.exe, having previously uninstalled Firebird 1.5, which I regularly use.
I created a database and tried to run the following script:
create table PROFILES (
PRF_ID char(1) not null,
DESCRIPTION varchar(15),
constraint PRF_PK primary key (PRF_ID));
create table USERS (
USR_ID varchar(12) not null,
LASTNAME varchar(15) not null,
NAME varchar(40) not null,
PROFILE char(1) default '2' not null,
PASSWD varchar(32) not null,
FORCE_NEW_PASS char(1) not null,
IS_ACTIVE char(1) default 'Y' not null,
constraint USR_PK primary key (USR_ID),
constraint USR_FK1 foreign key (PROFILE) references PROFILES (PRF_ID),
constraint USR_CHK1 check (FORCE_NEW_PASS in ('Y', 'N')),
constraint USR_CHK2 check (IS_ACTIVE in ('Y', 'N')));
...when the second statement is run I receive the following error:
ISC ERROR CODE:335544345
ISC ERROR MESSAGE:
lock conflict on no wait transaction
unsuccessful metadata update
object PROFILES is in use
Statement: create table USERS (
USR_ID varchar(12) not null,
LASTNAME varchar(15) not null,
NAME varchar(40) not null,
PROFILE char(1) default '2' not null,
PASSWD varchar(32) not null,
FORCE_NEW_PASS char(1) not null,
IS_ACTIVE char(1) default 'Y' not null,
constraint USR_PK primary key (USR_ID),
constraint USR_FK1 foreign key (PROFILE) references PROFILES (PRF_ID),
constraint USR_CHK1 check (FORCE_NEW_PASS in ('Y', 'N')),
constraint USR_CHK2 check (IS_ACTIVE in ('Y', 'N')))
The text was updated successfully, but these errors were encountered: