[Firebird-net-provider] COALESCE in Blob fields????

[Patrick A. <pat...@gm...>]

Hello... I know here is not a good place to ask this.. but...

Does any body know how to make any WHERE statament in BLOB fields ??? (text=
=20
ou binary) ???=20

If I take off my column of CLOP from the where statament, it works fine...=
=20
If I try to change from =3D to LIKE.. doesn=B4t work too.

Thanks

Patrick


this is my proc:

---------------
SET TERM ^ ;

CREATE PROCEDURE SPTBL_TEST5CLOP_SELECTSEARCH=20
(
 "iid" INTEGER,
 "iCLOP_FIELD" BLOB SUB_TYPE 1 SEGMENT SIZE 80
)
RETURNS=20
(
 "id" INTEGER,
 CLOP_FIELD BLOB SUB_TYPE 1 SEGMENT SIZE 80
)
AS
BEGIN
 FOR=20
 SELECT
 "id",=20
 "CLOP_FIELD"
 FROM "test5Clop"
 WHERE
 COALESCE("test5Clop"."id", 0) =3D COALESCE(:"iid", "test5Clop"."id", 0) AN=
D
 COALESCE("test5Clop"."CLOP_FIELD", '') =3D COALESCE(:"iCLOP_FIELD",=20
"test5Clop"."CLOP_FIELD", '')
 INTO
 :"id",=20
 :"CLOP_FIELD"
 DO=20
 BEGIN
 SUSPEND;
 END
END
^

SET TERM ; ^

GRANT SELECT ON "test5Clop" TO PROCEDURE SPTBL_TEST5CLOP_SELECTSEARCH;

GRANT EXECUTE ON PROCEDURE SPTBL_TEST5CLOP_SELECTSEARCH TO SYSDBA;
--------------