At 11:05 AM 20-04-01 -0700, you wrote:

>DROP INDEX RBLIKEWORDS
>DROP INDEX RBWORDWORDS
>DROP TABLE WORDS
>
>If I do this in DSQL I get an error
>
>invalid token 'DROP'

DSQL can take only one statement - here you have three.

A script would look like this:

DROP INDEX RBLIKEWORDS;
commit;
DROP INDEX RBWORDWORDS;
commit;
DROP TABLE WORDS;
commit;

But if you have any other tables that refer to this one through FOREIGN or other constraints, or triggers, you will continue to get the OBJECT IS IN USE error.
Also check whether you have some uncommitted transactions hanging around on the DSQL or Cursor pages...

Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________