View Incident Report

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 and Workarounds

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

Resolution

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap