Subject | RE: [IBO] Scripting problem |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2003-04-10T09:07:37Z |
Thanks for hand-holding :)
This worked.
Another question on the same topic. I use TIB_Scripts to update my database.
Sometimes they contain lots of changes.
When some error happens in the middle of the script, then next time I can't run it any more, because some changes have been commited and give exceptions.
Is the only solution to put all commited changes into different scripts?
Riho-Rene Ellermaa
senior programmer
Hansabank
This worked.
Another question on the same topic. I use TIB_Scripts to update my database.
Sometimes they contain lots of changes.
When some error happens in the middle of the script, then next time I can't run it any more, because some changes have been commited and give exceptions.
Is the only solution to put all commited changes into different scripts?
Riho-Rene Ellermaa
senior programmer
Hansabank
> Try to put a COMMIT after *each* DDL statement and re-run the
> script and see if
> that helps.
>
>