Subject Re: [firebird-support] Re: FB3 returning clause and new API
Author Mark Rotteveel
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 mse00000@... [firebird-support]" <firebird-support@yahoogroups.com>
Aan: <firebird-support@yahoogroups.com>
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 nsg@... 
[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 <mse00000@...> ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-digest@yahoogroups.com firebird-support-fullfeatured@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscribe@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/