You either need to generate the necessary metadata yourself, but then you either have to guess, or have the user provide the type. You can't use openCursor as insert ... returning doesn't have a cursor; just like an executable procedure it has a single result that is returned on execute.
Mark ----- Bericht beantwoorden ----- Van: "Martin Schreiber [email protected] [firebird-support]" <[email protected]> Aan: <[email protected]> Onderwerp: [firebird-support] Re: FB3 returning clause and new API Datum: do, sep. 15, 2016 14:55 On Thursday 15 September 2016 12:25:31 Norbert Saint Georges [email protected] [firebird-support] wrote: > > below, a bit dirty but functional code in codetyphon, reading the > buffer is RS > Thanks, but do I read the code correct, that you also use IAttachment.prepare() in order to get the messagemetadata? Does this cause an additional server roundtrip? With IAttachment.execute() there is no messagemetadata available and with the statement " insert into TABLE1 (STR1) values ('aabbccdd') returning PK " IAttachment.openCursor() seems not to work. Martin ------------------------------------ Posted by: Martin Schreiber <[email protected]> ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links https://info.yahoo.com/legal/us/yahoo/utos/terms/
