Hello,

please can anymore explain what does this error mean?
"DBISAM Engine Error # 11949 SQL parsing error - You cannot perform a UNION, INTERSECT, or EXCEPT operation without the ALL clause on
queries containing BLOB columns in SELECT SQL statement at line 1, column 154"

thanks

Hiba,

<< please can anymore explain what does this error mean?
"DBISAM Engine Error # 11949 SQL parsing error - You cannot perform a
UNION, INTERSECT, or EXCEPT operation without the ALL clause on queries
containing BLOB columns in SELECT SQL statement at line 1, column 154" >>

DBISAM cannot execute any UNION, INTERSECT, or EXCEPT queries that contain
BLOB expressions in the SELECT list for the involved queries unless you are
using UNION ALL, INTERSECT ALL, or EXCEPT ALL.  The reason for this is how
the records are evaluated to determine if they are unique.

--
Tim Young
Elevate Software
www.elevatesoft.com