Subject | Re: [IBO] "object %o is in use"-Error because of CacheStatementHandles (firebird 2.0.1) |
---|---|
Author | Andreas Filsinger |
Post date | 2007-05-12T13:55:57Z |
Hi Jason,
# my last statement is not "DROP DATABASE" but "DROP TABLE" 8-O
# here is my list "How" i did things:
IB_DSQL: create table CLUB$2101 (RID DOM_REFERENCE NOT NULL)
IB_DSQL: alter table CLUB$2101 add constraint PK_CLUB$2101 primary key
(RID)
<# some IBO-Schema Caching Code here #>
IB_Query: INSERT INTO CLUB$2101 ( RID) VALUES (7304393)
: select AUFTRAG.RID from AUFTRAG join CLUB$2101 on
(CLUB$2101.RID=AUFTRAG.RID) where (NUMMER is null)
ORDER BY STRASSE ASC
, ZAEHLER_NUMMER ASC
, ART ASC
IB_DSQL: drop table CLUB$2101
hm, I'll do a bit more debugging ...
Andreas
# my last statement is not "DROP DATABASE" but "DROP TABLE" 8-O
# here is my list "How" i did things:
IB_DSQL: create table CLUB$2101 (RID DOM_REFERENCE NOT NULL)
IB_DSQL: alter table CLUB$2101 add constraint PK_CLUB$2101 primary key
(RID)
<# some IBO-Schema Caching Code here #>
IB_Query: INSERT INTO CLUB$2101 ( RID) VALUES (7304393)
: select AUFTRAG.RID from AUFTRAG join CLUB$2101 on
(CLUB$2101.RID=AUFTRAG.RID) where (NUMMER is null)
ORDER BY STRASSE ASC
, ZAEHLER_NUMMER ASC
, ART ASC
IB_DSQL: drop table CLUB$2101
hm, I'll do a bit more debugging ...
Andreas