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?
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"
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
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
Thank you Vlad.
That is important to know, since I'm using PHP applications with non-persistent
connections.