|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 afterThe difference with "USERS2 not found" is probably the transaction
> 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
> What can be differents?
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