Icon View Incident Report

Serious Serious
Reported By: Rolf Frei
Reported On: 8/2/2002
For: Version 3.12 Build 1
# 1168 Executing 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.

Resolution Resolution
Fixed Problem on 8/3/2002 in version 3.13 build 1