At 20/03/2002 11:41 PM, you wrote:

>It seems like I'm teasing you, but no.
>Both DYN (metadata mangler) and DFW (data and metadata mangler at commit
>time) are industrial-strength can of worms. Avoid getting in their way or it
>would be like a train hitting a tricycle.
>You mixed DDL and DML. Usually, tools handle auto-commit DDL and manual
>commit DML, but this is not mandatory to use separate transactions for them
>and in isql, it's an option. By renaming a field to the original name, I can
>imagine (but I'm not sure) how the disaster happens. You need the commits.

Everything is autocommitted. I use IBO with the IB_Transaction settings
AutoCommit=True and ServerAutoCommit=True.

I thought that it could've been that I didn't have autocommit on, I know at
one time I did and errors showed up. So, I changed everything to
autocommit. But, Ann's suggestion for extra steps seems to work, I tested
it outside of my application, now I need to test it in my application.

Thanks for the reply and explanation.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)