Subject Re: [firebird-support] Converting a MEMO into a string
Author Doru Constantin
This statement kill my server (FB2.0.0.6595 UNSTABLE - build from cvs on Win-XP) !!!
----- Original Message -----
From: clementdoss
Sent: Monday, March 01, 2004 2:47 AM
Subject: [firebird-support] Converting a MEMO into a string


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
where (RDB$SYSTEM_FLAG=0) and
(RDB$VIEW_SOURCE is not null)

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


Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

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

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