Subject Re: [IBO] Problem with scripts
Author Geoff Worboys (TeamIBO)
> I want to run following script in IBO4.2Fp TIB_SCript (I'm hacking ISC4)

Always fun :-)

> .. and I get error "USERS2 not found". When I include commit after
> CREATE TABLE, it seems to be working ok, except I can't access my
> databases (and ISC4) anymore - the ISC4 is screwed up. When I run
> the same script using IBAdmin it works perfectly and ISC4 is also
> OK.

> What can be differents?

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
Telesis Computing