Subject Re: [firebird-support] Re: Table Not Found
Author Thomas Steinmaurer
> --- In firebird-support@yahoogroups.com, 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