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

2016-09-15 Thread Martin Schreiber mse00...@gmail.com [firebird-support]
On Thursday 15 September 2016 12:25:31 Norbert Saint Georges n...@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

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

2016-09-15 Thread Martin Schreiber mse00...@gmail.com [firebird-support]
On Thursday 15 September 2016 15:06:58 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] wrote: > 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

[firebird-support] Problem querying MON$STATEMENTS table

2016-09-15 Thread gregorkob...@yahoo.com [firebird-support]
Hello I have a problem when i querying the MON$STATEMENS table on Server 2.5.5 and also 2.5.6 Do the follow steps: Open a connection to the database, then start a transaction an open a table to show the content and keep it open/active Now run the follow statement "SELECT * FROM

Re: [firebird-support] Problem querying MON$STATEMENTS table

2016-09-15 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Friday, September 16, 2016, 12:02:28 AM, Gregor Kobler wrote: > I have a problem when i querying the MON$STATEMENS table on Server 2.5.5 and > also 2.5.6 > > Do the follow steps: > > Open a connection to the database, then start a transaction an open > a table to show the content and keep it

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

2016-09-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.

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

2016-09-15 Thread Martin Schreiber mse00...@gmail.com [firebird-support]
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

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

2016-09-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.

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

2016-09-15 Thread Martin Schreiber mse00...@gmail.com [firebird-support]
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

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

2016-09-15 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Martin Schreiber mse00...@gmail.com [firebird-support] a écrit : > 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 >>>

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

2016-09-15 Thread Martin Schreiber mse00...@gmail.com [firebird-support]
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

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

2016-09-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.