> --- In [email protected], Thomas Steinmaurer<ts@...> wrote: >> >>> Tools: Delphi 2006, IB Objects (4.7+) and FB 2.1.3 >>> >>>> From Delphi, I'm creating a table as part of a transaction. When I >>>> attempt to open the table after it's created, I get a "Table unknown" >>>> error. I have the same problem with every available isolation level, yet >>>> the same code worked with Firebird 1.5x. >>> >>> Has something changed in Firebird that prevents me from seeing the new >>> table from within the transaction in which it was created? >> >> Do you isse a commit after creating the thable and before actually using >> the table? >> >> >> -- >> With regards, >> Thomas Steinmaurer (^TS^) >> Firebird Technology Evangelist >> >> http://www.upscene.com/ >> >> Do you care about the future of Firebird? Join the Firebird Foundation: >> http://www.firebirdsql.org/en/firebird-foundation/ >> > > I have AutoCommit set to true on my transaction component. So that should > commit the table after it's created?
I think so, yes. With what component do you execute the DDL? If it is TIB_Script, you might try explicit COMMIT statements in the script. Regards, Thomas
