firebird-test

[Marek K. <ma...@ga...>]

Why Firebird 1.5 didn't return record in "select ... for update"

I have two procedures=20

CREATE PROCEDURE BLOK_POLA (
   P_POL_ID_POLA INTEGER)
RETURNS (
   R_POL_ID_POLA INTEGER)
AS
BEGIN
  SELECT POL_ID_POLA
  FROM POLA
  WHERE POL_ID_POLA =3D :R_POL_ID_POLA
  FOR UPDATE OF POL_ID_POLA
  INTO :R_POL_ID_POLA;
  SUSPEND;
END

and=20

CREATE PROCEDURE BLOK_POLA_A(
   P_POL_ID_POLA INTEGER)
RETURNS (
   R_POL_ID_POLA INTEGER)
AS
BEGIN
  SELECT POL_ID_POLA
  FROM POLA
  WHERE POL_ID_POLA =3D :R_POL_ID_POLA
  INTO :R_POL_ID_POLA;
  SUSPEND;
END
select * from BLOK_POLA_A(1) it return row
select * from BLOK_POLA(1) no row is return
(I connect to database using gds32.dll and fbclient.dll)
P.S. When I use isql everything is ok

Marek.