Re: [Firebird-net-provider] Exception thrown when using transactions and FbBatchExecution

2010-08-24 Thread Gareth
Ok great, I'll take a look when I get the chance - thanks your help Gareth -- View this message in context: http://firebird.1100200.n4.nabble.com/Exception-thrown-when-using-transactions-and-FbBatchExecution-tp2336286p2336827.html Sent from the firebird-net-provider mailing list archive at Nabb

Re: [Firebird-net-provider] Exception thrown when using transactions and FbBatchExecution

2010-08-24 Thread Jiri Cincura
On Tue, Aug 24, 2010 at 14:34, Gareth wrote: > are there technical difficulties in doing Nothing that can't be solved. > this?  If not, is it something that you would consider implementing? Sure. You can either sponsor this feature or implement it on your own or wait till more people will need

Re: [Firebird-net-provider] Exception thrown when using transactions and FbBatchExecution

2010-08-24 Thread Gareth
Oh ok i see, thank you. I am new to firebird (all previous work done ith MSSQl and MYSQL before) so if this next question is not possible for some reason please say. I would think that I can not be the only person that would find it extremly useful to be able to provide a transaction and command

Re: [Firebird-net-provider] Exception thrown when using transactions and FbBatchExecution

2010-08-24 Thread Jiri Cincura
On Tue, Aug 24, 2010 at 14:15, Gareth wrote: >>> You can put there commit statement. > > Sorry I don't know what you mean, could you show a quick example or maybe a > link to some up todate documentatin for the provider.  The only stuff i > could find is years out of date. Same as you put insert

Re: [Firebird-net-provider] Exception thrown when using transactions and FbBatchExecution

2010-08-24 Thread Gareth
>> You can put there commit statement. Sorry I don't know what you mean, could you show a quick example or maybe a link to some up todate documentatin for the provider. The only stuff i could find is years out of date. Thanks -- View this message in context: http://firebird.1100200.n4.nabbl

Re: [Firebird-net-provider] Exception thrown when using transactions and FbBatchExecution

2010-08-24 Thread Jiri Cincura
On Tue, Aug 24, 2010 at 11:01, Gareth wrote: > Unless ALL statements execute fine > nothing will be inserted ie it seems that there is an implicit transaction > wrapped around ALL statements and that it is not possible to commit after > each statement, is this correct? You can put there commit st

Re: [Firebird-net-provider] Exception thrown when using transactions and FbBatchExecution

2010-08-24 Thread Gareth
Hi thanks for the quick response! Im at a bit of a loss as to the purpose of the boolean argument for execute now. Ive experimeted quickly (after your response) and it seems that if I leave Execute() empty, or provide it with either a true or false argument it makes no difference to the outcom

Re: [Firebird-net-provider] Exception thrown when using transactions and FbBatchExecution

2010-08-24 Thread Jiri Cincura
On Tue, Aug 24, 2010 at 10:18, Gareth wrote: > how can I register a transaction to use with the FbBatchExecution class You can't. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

[Firebird-net-provider] Exception thrown when using transactions and FbBatchExecution

2010-08-24 Thread Gareth
Hi all, I think that I must be doing something wrong - when I run the code shown below I get an exception thrown on the line "batch.Execute(false);". using (FbConnection connection = new FbConnection(connectionString)) { connection.Open(); using (FbTransaction transaction = connection