Thanks for the explanation Adam.

Cheers,

Ryan Thomas
TransActive Systems

P: (02) 4322 3302
F: (02) 4325 1141
E: ryan@...
W: http://www.transactive.com.au/

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
> Sent: Tuesday, 15 November 2005 3:31 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: DDL and DML in the one transaction
>
> > Adam mentioned in the post 'dbExpress and transactions' that mixing
> DDL and
> > DML in the one transaction will cause 'funny' things to happen, can
> someone
> > please elaborate on this - what's going to / could happen?
> >
>
> A lot of the time you will get away with it, the problems start when
> you create a field in a table then try and populate it with data
> before you commit, that sort of thing.
>
> If you add a field to TableA, then update TableB (and TableB has no
> triggers that affect TableA), then there is no problem.
>
> Values that you **think** are populated may not be. Give it a go
> yourself one day when you are bored. Queries like update table set
> somedate = 'now' also behaves unexpectedly.
>
> In short, it is more likely to cause data inconsistencies than some
> half upgraded database.
>
> Adam
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Fair play? Video games influencing politics. Click and talk back!
> http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>