26.11.2013 17:03, Kjell Rilbe wrote:
>
>> Anything wrong with these options etc?
>
> Tried to add rd.Close after the for loop, but it didn't help. What did
> help was to close the connection and reopen it between the select commit
> and the starting the transaction for the drop.
>
> But why is that
26.11.2013 01:54, Kjell Rilbe wrote:
>
> Scenario, in a single connection I do this:
>
> 1. Start transaction.
> 2. Create table.
> 3. Commit.
> 4. Start transaction.
> 5. Insert rows.
> 6. Select using join with other tables.
Handles for both INSERT and SELECT statements must be destroyed.
> 7.
I'm using Fb 2.5 classic
So superserver is the solution?
--- In firebird-support@yahoogroups.com, "arda" wrote:
>
> I have web clients, desktop clients and some service applications connected
> to the database. And I'm not the only one writing applications on the
> database.
>
> I have great
> I think classic and superclassic do not support meta data change while in
> use, only superserver support it.
You have to use script to change procedures. Clients will see/use the old
version until reconnect.
Not so easy with tables though.