Subject Re: cannot drop table
Author willy.bojit
--- In firebird-support@yahoogroups.com, "bill2janesoft@..."
<bill2janesoft@...> wrote:
>
> Milan Babuskov wrote:
> > Keep DDL operations in separate transactions and you should be fine.
> >
>
> Thanks, but I did not start any transaction, furthermore connection
handle (B)
> is read-only.
>
> BTW my code works for ms access and msde, may be it is related to fb's
> restriction that Ann suggested.
>
> bill
>
MSAccess and MSDE are probably running with "auto commit" on. Their
transactions are complete, although you specifically did no
transaction handling. If you use multiple databases, you must be aware
of the differences and program to the lowest common denominator.

WB