The docs say that using ExecuteImmediate (From memory) will allow DDL
without triggering a Schema Refresh.

However if I don't refresh the Schema will I be able to see / use the table.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Jason Wharton wrote:

> If you use a separate connection and do your temp table operations in it,
> isolated from the other stuff, then perhaps it won't trigger the schema
> cache to be refreshed.
>
> Jason
>
>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
>> Behalf Of Robert martin
>> Sent: Thursday, May 17, 2007 3:52 PM
>> To: IBObjects@yahoogroups.com
>> Subject: Re: [IBO] performance issue when adding tables
>>
>>
>> Hi Jason
>>
>> I don't know if I need the temp tables to show in he cache. I do use
>> them so I guess so. I suppose what I am after is a partial
>> refresh. i.e.
>>
>> a) create new table
>> b) Add new table details to existing schema
>> c) Access table
>>
>> as opposed to the current situation (I think)
>>
>> a) create new table
>> b) Access (any) table, Entire schema is refreshed
>> c: Access table
>>
>> Hope this helps your understanding of the situation :)
>>
>> Rob Martin
>> Software Engineer
>>
>> phone +64 03 377 0495
>> fax +64 03 377 0496
>> web www.chreos.com
>>
>> Wild Software Ltd
>>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>