Yep, ServerAutoCommit helped.

I can't copy ISC4 to another file, because the program runs in client computer and probably doesn't have access to server files.
I display big warning with friendly letters "please copy ISC4 before proceeding". It will be shown only the very first time when my program runs.


Riho-Rene Ellermaa
senior programmer
Hansabank

The difference with "USERS2 not found" is probably the transaction
isolation or commit method - as the table must be committed before
adding data, so presumably IBAdmin is autocommitting in some way.

The second issue - cant access ISC4 anymore - seems odd. However you
could try setting ServerAutoCommit to true and see if that helps.

Personally I prefer to copy ISC4 out to a new database, then make my
DDL changes to the copy and then move it back into place.

--
Geoff Worboys - TeamIBO




[Non-text portions of this message have been removed]