Icon View Incident Report

Serious Serious
Reported By: Elevate Software
Reported On: 10/28/2000
For: Version 2.04 Build 1
# 648 SQL SELECT Queries with a Live Result Set and a Limited Field Set That Includes BLOBs Causes Error

Executing a SELECT query that will generate a live result set (RequestLive=True), has a limited number of fields from the source table (not a SELECT *), includes BLOB field(s) as part of the SELECT fields, and includes a BLOB field in the WHERE clause conditions, will generate a "Field not Found" error.

SELECT category, notes
FROM biolife
WHERE notes LIKE '%Mexico%'

Comments Comments and Workarounds
The workaround is to use a SELECT * (all fields).

Resolution Resolution
Fixed Problem on 10/29/2000 in version 2.05 build 1