On Fri, Nov 12, 2010 at 15:45, Marc Bettex <bet...@epsitec.ch> 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;
>
> As long as I want to retrieve only one column, I can use the
> FbCommand.ExecuteScalar() method which works fine. But if I want to retrieve
> more than one column, I must use the FbDataAdapter.Fill(...) method which
> does not work.
>
> I have seen a bug report (DNET-319) indicating that this feature was not
> working/not implemented. Is there any workaround to make it work, beside
> executing an insert and then a query?
>
> Thank you very much and have a nice week-end,

The returning clause behaves like filling output parameters. Not resultset.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Centralized Desktop Delivery: Dell and VMware Reference Architecture
Simplifying enterprise desktop deployment and management using
Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
client virtualization framework. Read more!
http://p.sf.net/sfu/dell-eql-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to