problem with create table.

suarahati · Post by **suarahati** » Wed 31 May 2006 02:40

Hi,

I have problem when want to create table in system. An error appear 'table id not found'.

I'm create table using script in program, and when I want to access the table I'm using as dynamic to the table component.

Can you please give the solution for the problem..

thanks..

Alex · Post by **Alex** » Wed 31 May 2006 09:03

I think your problem is caused by transaction isolation level. In IBCScript all DDL statements (table creation and so on) are executes and committed in dedicated transaction. All other statements are executed in base transaction (TIBCScript.Transaction). So if base transaction has isolation level Snapshot (default settings) it will never access tables created in other transactions untill restart. To solve this issue you should setup TIBCScript.Transaction with isolation level Read Committed.