Icon View Incident Report

Serious Serious
Reported By: Lars Black
Reported On: 1/1/2001
For: Version 2.06 Build 1
# 707 Including a BLOB Column in a SQL SELECT Query with a GROUP BY Clause Causes #8708 Error

Executing the following SQL will cause an 8708 error.

{ One of the columns in P is a BLOB }

Select P.*, Sum(S.Stock) As Stock
from Product
P Left Outer Join StockLocation S On S.ProductID = P.ID
Where P.ID=10
Group By ID

Resolution Resolution
Fixed Problem on 1/10/2001 in version 2.07 build 1