Re: [firebird-support] PHP PDO fetch from insert... into... or from stored procedure without suspend clause? Is it possible?

2016-09-12 Thread jonatan.laurit...@yahoo.dk [firebird-support]
But it looks like from the Yii2 code that select and insert...returning is handled alike in the PHP Data Objects. Can it be possible that Firebird PDO driver deviates from the official PDO interface. Who develops pdo_firebird.dll and is it possible to adapt is behavior?

Re: [firebird-support] PHP PDO fetch from insert... into... or from stored procedure without suspend clause? Is it possible?

2016-09-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.09.2016 12:19, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > Is is possible to execute insert... into... and fetch result at all with > Firebird? No. "insert into returning" produce singleton result, not result set. You must threat it the same way as "execute procedure"

[firebird-support] PHP PDO fetch from insert... into... or from stored procedure without suspend clause? Is it possible?

2016-09-12 Thread jonatan.laurit...@yahoo.dk [firebird-support]
I am trying to fetch data from PDOStatement with insert... into... or stored procedure (without suspend clause) in PHP using PHP data objects (PDO) with Firebird. And I am getting the error: SQLSTATE[HY000]: General error: -502 Cursor is not open Is is possible to execute insert... into... and

Re: Re: Re: [firebird-support] Optimizer request

2016-09-12 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi, i do not know what server do you use but if i run simple query on FB3 select o.* from partners p inner join orders o ON p.partid = o.partid WHERE p.country = 'Spain'; on non propagated with data tables, plan is: PLAN JOIN (O NATURAL, P INDEX (PK_PARTNERS)) but if i fill tables with test data

[firebird-support] Re: When is cache cleared on SuperServer

2016-09-12 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
Thank you Vlad. That is important to know, since I'm using PHP applications with non-persistent connections.