I can't see why this doesn't work.
I get "Conversion error from string blob", the procedures that the select
returns are very small, much less than 32k


CREATE PROCEDURE UP_STD_SPCHECK
returns (PROCEDURENAME VARCHAR(2048),
DESCRIPTION VARCHAR(30000))
AS

begin
/* select * from up_std_spcheck */

FOR SELECT DISTINCT SP.RDB$PROCEDURE_NAME,
cast(SP.RDB$PROCEDURE_SOURCE as varchar(30000))
FROM RDB$PROCEDURES SP
WHERE RDB$PROCEDURE_NAME LIKE 'UP%'
INTO :PROCEDURENAME, :DESCRIPTION
DO BEGIN
SUSPEND;
END
end



--
Nick
-----We Solve your Computer Problems---
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ivan Prenosil
Sent: 30 September 2005 17:21
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Blob retreival

> Firebird 1.5.2 & isql.
>
> Trying to extract a list of all procedures that contain a given string,
> Including the line of the procedure that contains the string.
> I can almost get there but the substring returns null
>
> select rdb$procedure_name, substring(rdb$description from 1 for 2048)
> from rdb$procedures
> where rdb$procedure_source like '%required_string%';

SUBSTRING does not support blobs. Either wait for Firebird 2, or use UDF.

Ivan


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]