Re: [Firebird-net-provider] Table is in use with FbBatchExecution

2006-10-20 Thread Carlos Guzmán Álvarez
Hello: > The script executes fine in Flamerobin, without the RECONNECT; row before > the "ALTER TABLE statment. > > Any ideas? Could please send to me the isql script that is giving you problems ?? ( to my private email ) Thanks in advance. -- Carlos Guzmán Álvarez Vigo-Spain

Re: [Firebird-net-provider] Table is in use with FbBatchExecution

2006-10-19 Thread Ulf
Hi, Were you able to fix this problem? I'm having the same problem. Im creating tables including the one named TPSPECIES. Im setting a primary key. ALTER TABLE TPSPECIES ADD PRIMARY KEY (SPECID); But when I come to this statement, the first of its kind ALTER TABLE TPASSORTMENT ADD CONSTRAINT

Re: [Firebird-net-provider] Table is in use with FbBatchExecution

2005-11-08 Thread [EMAIL PROTECTED]
Hello: >I'm pretty sure it's not a server issue. there are situations where I >can reproduce it everytime with the provider and it works great in EMS >Firebird Manager ... Ok send it then to my private email. -- Best regards Carlos Guzmán Álvarez Vigo-Spain --

Re: [Firebird-net-provider] Table is in use with FbBatchExecution

2005-11-08 Thread Julien Ferraro
Carlos Guzmán Álvarez wrote: Hello: Carlos, I can provide you a database (zipped backup) and a script to reproduce it every time. Tell me if you need it it's a 6 Mb download Hummm i can do a test on this to see if something is getting wrong with the transaction handling in that class but i t

Re: [Firebird-net-provider] Table is in use with FbBatchExecution

2005-11-08 Thread Carlos Guzmán Álvarez
Hello: Carlos, I can provide you a database (zipped backup) and a script to reproduce it every time. Tell me if you need it it's a 6 Mb download Hummm i can do a test on this to see if something is getting wrong with the transaction handling in that class but i think it maybe a server issue

[Firebird-net-provider] Table is in use with FbBatchExecution

2005-11-08 Thread Julien Ferraro
Hello, I have a strange problem with FbBatchExecution. Sometimes when I execute a script that creates tables and foreign keys I get the following error : Table xxx is in use. to execute the script I do : Batch.Execute(true); But it's like if the commit is not done. On an empty database this