Dayna,

> The error changed to this.
>
> --> SQL Message: SQL ERROR CODE:-607
>
> SQL ERROR MESSAGE:
>
> This operation is not defined for system tables.
>
> --> SQL Text: COMMIT
> --> Error text: ISC ERROR CODE:335544351
>
> ISC ERROR MESSAGE:
> unsuccessful metadata update
> object PATIENT is in use
>
> STATEMENT:
> TIB_DSQL: "<TApplication>.frmUpdaterMain.IB_Script1.<TIB_DSQL>."
>
> There is no one connected to the db server. And no references to the
> PATIENT table in the script being run.
>
> I have no idea how to proceed.

This is really strange...

Will you please turn on the SQL trace monitor and provide the output from
the entire script?

I'd like to look everything over and see if there is more going on here.

If all else fails, will you please send me a sample application
demonstrating this problem?

Thanks,
Jason Wharton