Thursday, 15 September 2016

Re: [firebird-support] Re: FB3 returning clause and new API

 

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@gmail.com [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@tetrasys.eu   [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@gmail.com>  ------------------------------------    ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++    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/

__._,_.___
Posted by: "=?utf-8?B?TWFyayBSb3R0ZXZlZWw=?=" <mark@lawinegevaar.nl>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)