Subject Re: [IBO] IB Script - New Tables not visible
Author Robert martin

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.


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?