Subject | Re: [IBO] IB Script - New Tables not visible |
---|---|
Author | Robert martin |
Post date | 2005-01-17T22:12:53Z |
Hi
I think it is not recommended to mix DDL and DML statements in the same
script, but I suspect inserting a 'Commit' before trying to use the new
tables may help.
Rob
ra8009 wrote:
I think it is not recommended to mix DDL and DML statements in the same
script, but I suspect inserting a 'Commit' before trying to use the new
tables may help.
Rob
ra8009 wrote:
>
> When executing a script, I want to add a table and then use an insert
> statement to add some values. However, my insert statements seem to be
> faling becuase they don't see the newly created tables. How do I make
> the new tables visible? Do I have to somehow update the schema cache?