Hi Steve
You can use many connects in one script
__________
connect ........;
some DDL;
connect ........; // Fb will disconnect and connect
some DML;
__________
Tom

> Hi,
> I'm making some major changes to a FB1 db and I've found I need to
> split the script into multiple sections and manually
> disconnect/reconnect between running each one to avoid errors.
>
> Are there some guidelines as to when this is needed? I've read that I
> need to have commits when switching between DDL & DML, but I still
> can't do everything with one script/connection.
>
> Thanks,
> Steve

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.422 / Virus Database: 237 - Release Date: 20.11.2002