Re: [firebird-support] FB3 returning clause and new API
On Thursday 15 September 2016 11:09:43 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 15.09.2016 11:14, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > > What if one wants to use > > IAttachment.execute() where no IStatement is available? > >(S)he must provide IMetadata built with builder. I am implementing a Firebird 3 connection component for MSEide+MSEgui (a Free Pascal toolkit) so I don't know the returned data of the statements in the first place. In case of input params I implemented an own IMessageMetadata derivate which uses the type information of TParam in order to setup the metadata. In case of "returning" the data type is unknown without parsing the SQL statement. It seems I always need to prepare the statement first? Martin ++ 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-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB3 returning clause and new API
15.09.2016 11:14, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > What if one wants to use > IAttachment.execute() where no IStatement is available? (S)he must provide IMetadata built with builder. -- WBR, SD. ++ 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-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB3 returning clause and new API
On Thursday 15 September 2016 10:29:27 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 15.09.2016 10:16, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > > And then how to get the data? > >Last two parameter of the methods is an output message where output data > is returned in. Signature of execute in firebird.pas is: " function execute(status: IStatus; transaction: ITransaction; inMetadata: IMessageMetadata; inBuffer: Pointer; outMetadata: IMessageMetadata; outBuffer: Pointer): ITransaction; " A value for outMetadata probably is available by IStatement.getOutputMetadata(). What if one wants to use IAttachment.execute() where no IStatement is available? How can one know if IAttachment.execute() or IAttachment.openCursor() must be called without having IStatement.getFlags() from a prepared statement other than parsing the SQL statement in user code? Does IAttachment.prepare() involve a server roundtrip? Thanks for your patience. Martin ++ 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-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB3 returning clause and new API
15.09.2016 10:16, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > And then how to get the data? Last two parameter of the methods is an output message where output data is returned in. -- WBR, SD. ++ 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-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB3 returning clause and new API
On Thursday 15 September 2016 09:01:04 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 15.09.2016 7:56, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > > How the values of a returning clause can be fetched with OOP-API? > >Use IAttachment::execute() for single execution of queries without > parameters and IStatement::execute() for the rest. And then how to get the data? Is using openCursor() not possible so one does not need to know if it is a SELECT or another statement? Martin ++ 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-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB3 returning clause and new API
15.09.2016 7:56, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > How the values of a returning clause can be fetched with OOP-API? Use IAttachment::execute() for single execution of queries without parameters and IStatement::execute() for the rest. -- WBR, SD. ++ 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-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/