Re: [Firebird-net-provider] RETURNING clause and Firebird .NET Provider

2010-11-12 Thread Jiri Cincura
On Fri, Nov 12, 2010 at 15:45, Marc Bettex wrote: > I'm currently using the ado.net firebird client 2.5.2 and I have some > problems with INSERT statements that have a RETURNING clause, such as > > INSERT INTO myTable(myColumn1) VALUES ('myValue1') RETURNING myColumn1, > myColumn2, myColumn3; > >

[Firebird-net-provider] RETURNING clause and Firebird .NET Provider

2010-11-12 Thread Marc Bettex
Hi, I'm currently using the ado.net firebird client 2.5.2 and I have some problems with INSERT statements that have a RETURNING clause, such as INSERT INTO myTable(myColumn1) VALUES ('myValue1') RETURNING myColumn1, myColumn2, myColumn3; As long as I want to retrieve only one column, I can use t

Re: [Firebird-net-provider] Returning clause

2007-09-23 Thread Jiri Cincura
On 9/23/07, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: > Hello: > > I'm pretty sure, that it has been working, isn't it? Am I try to debug > > and locate the problem or it's just as is? > Huumm if i remember well that was implemented using ExecuteNonQuery > calls with output parameters but i

Re: [Firebird-net-provider] Returning clause

2007-09-23 Thread Carlos Guzmán Álvarez
Hello: > I'm pretty sure, that it has been working, isn't it? Am I try to debug > and locate the problem or it's just as is? Huumm if i remember well that was implemented using ExecuteNonQuery calls with output parameters but i will try to check it tomorrow :) -- Carlos Guzmán Álvarez Vigo-Spa

[Firebird-net-provider] Returning clause

2007-09-23 Thread Jiri Cincura
Hi *, I'm wondering why this code doesn't work. It simply returns no rows (the Read method on the first call returns false). But the ExecuteScalar gives me the first returned column right. ... cmd.CommandText = "insert into sometable values (10, 'ten') returning id, name"; using (FbDataReader rea