From: Marek K. <ma...@ga...> - 2003-03-20 17:46:57
|
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. |