This statement kill my server (FB2.0.0.6595 UNSTABLE - build from cvs on Win-XP) !!!

----- Original Message -----
From: clementdoss
To: firebird-support@yahoogroups.com
Sent: Monday, March 01, 2004 2:47 AM
Subject: [firebird-support] Converting a MEMO into a string


Hi,

I have a MEMO field that contains plain text information.
I would like to show the first 4000 characters of it in my query.

for example :

SELECT CAST( substring( RDB$VIEW_SOURCE from 1 for 4000) as varchar
(4000) ) as VIEW_CODE
FROM RDB$RELATIONS R
where (RDB$SYSTEM_FLAG=0) and
(RDB$VIEW_SOURCE is not null)

gives me the following error :
conversion error from string "BLOB"

Cl�ment


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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