Icon View Incident Report

Serious Serious
Reported By: Eddy Poullet
Reported On: 10/1/2001
For: Version 3.01 Build 1
# 891 Cannot Perform an IS NULL Comparison on Bytes Fields in an SQL or Filter Expression

How can I test if a byte field is empty. The following SQL statement with x being a byte field of 230 bytes raises an error "DBisam # 11949 sql error - type mismatch between column X and constant 'NULL' in WHERE or JOIN clause".

Select X from DB where x is not null

Comments Comments
This problem also exists in version 2.11.

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