Tim

If I replace count(_encoded) with count(an integer field) its OK otherwise I get a 9494 error - should DBISAM be holding the blobs open for a count?

select count(_encoded) from eln where upper(_encoded) like upper('%mime-version%')

Roy Lambert

Roy,

<< If I replace count(_encoded) with count(an integer field) its OK
otherwise I get a 9494 error - should DBISAM be holding the blobs open for a
count?

select count(_encoded) from eln where upper(_encoded) like
upper('%mime-version%') >>

Figures that you'd post this and I would read it right after I did a new
release.   It's a problem with using BLOB fields in single-row SELECT
statements.  A fix will be in the next build.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


At least its not a wildly common requirement - I only did it cos I'm still trying to figure out the table structure I want to use.

Roy Lambert