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;
--------------
|
