create table "\Memory\A" (vc varchar(50));
create table "\Memory\B" (mem memo);
insert into "\Memory\B" values('blah');
select vc 
from "\Memory\A"
union all 
select mem 
from "\Memory\B"

---

 Comments and Workarounds

---

The workaround is to not mix and match BLOB columns with non-BLOB columns in UNION ALL queries.

---

 Resolution

---

Fixed Problem on 7/20/2005 in version 4.21 build 7

---

 Products Affected

---

DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source