Reported By: Rolf Frei Reported On: 8/2/2002 For: Version 3.12 Build 1
# 1168Executing an SQL SELECT Query Containing a Sub-Select Causes an #15002 DBISAM_UNCOMPRESS Error I get this error if I do the following in DBSYS 3.12 and server 3.12:
1. I run this Query:
Select * from prices where partno in
(Select PartNo from parts Where
(maingroup = 1 and category = 4 and subcategory = 3) or
(maingroup = 1 and category = 4 and subcategory = 4))
2. Now I try to open the Parts table.
On this open I get the error 15002. If I first unprepare the query statement, I don't get the error. It must be a problem with the subquery as this only happens if there is a subquery with the table I want then to open.
ResolutionFixed Problem on 8/3/2002 in version 3.13 build 1