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