At 20/03/2002 10:44 AM, you wrote:

>Hello,
>Using FB1 I have a script to reorganize my DB with DDL-Statements
>like this:
>ALTER TABLE ARTIKEL DROP CONSTRAINT FK_ARTIKEL_U_MWST;
>commit;
>ALTER TABLE ARTIKEL DROP CONSTRAINT FK_ARTIKEL_V_MWST;
>commit;
>
>The error "index is in use" comes at the second alter table. What
>does it mean? Thank You

You're not the only one with that problem. I have the same one. And, I
can't find the problem either. Out of curiosity, did this work properly
before FB 1.0? I've only tried it in FB 1.0.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)