Re: [Firebird-net-provider] INSERT work but nothing do...

2011-05-29 Thread wiwian
Uff, I find and now all work fine:) Najtansze samochody w Polsce! Odwiedz >> http://linkint.pl/f29ab -- vRanger cuts backup time in half-while increasing se

Re: [Firebird-net-provider] INSERT work but nothing do...

2011-05-29 Thread wiwian
How I write, with commit I get the same result, all work but without effect in the base... Something else is wrong but what? Why SQL query is executed without effect? Is propably my fault but wher I must serch?? Najlepsze oferty n

Re: [Firebird-net-provider] INSERT work but nothing do...

2011-05-29 Thread de Carvalho Neto , João Dias
You don't committed the transacion. try to execute fbCommand1.Transaction.Commit(); After the fbCommand1.ExecuteNonQuery(); statement * * *João Dias de Carvalho Neto* * * *http://www.bjsoftware.com.br* *Perfil Profissional* +55-(87)-8811-8945 j...

Re: [Firebird-net-provider] INSERT work but nothing do...

2011-05-29 Thread Mark Rotteveel
On 29-5-2011 15:24, wiwian wrote: > Hi > I have autocommit and dont need insert this (Inserting commit nothing > do)... I write the same in Borland C++ and all work perfect without commit: > > Form2->pFIBQuery1->SQL->Text="INSERT INTO TEST (NUMER...) VALUES > ('NUMER',...)"; > Form2->pFIBTransactio

Re: [Firebird-net-provider] INSERT work but nothing do...

2011-05-29 Thread wiwian
Hi I have autocommit and dont need insert this (Inserting commit nothing do)... I write the same in Borland C++ and all work perfect without commit: Form2->pFIBQuery1->SQL->Text="INSERT INTO TEST (NUMER...) VALUES ('NUMER',...)"; Form2->pFIBTransaction1->StartTransaction(); Form2->pFIBQuery1->Ex

Re: [Firebird-net-provider] INSERT work but nothing do...

2011-05-29 Thread Gerdus van Zyl
It is because you did not commit the transaction. e.g fbCommand1.Transaction.Commit() On Sun, May 29, 2011 at 1:40 PM, wiwian wrote: > Hi > Why this don't write nothing to the base in C# express 2010 & > NetProvider 2.6? > >         private void button2_Click(object sender, EventArgs e) >        

[Firebird-net-provider] INSERT work but nothing do...

2011-05-29 Thread wiwian
Hi Why this don't write nothing to the base in C# express 2010 & NetProvider 2.6? private void button2_Click(object sender, EventArgs e) { fbConnection1.Open(); fbCommand1.Transaction = fbConnection1.BeginTransaction(); fbCommand1.CommandTe