Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
error in SQL |
Wed, May 6 2009 5:02 AM | Permanent Link |
Hiba Hable | 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 |
Wed, May 6 2009 11:47 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |