Icon View Incident Report

Serious Serious
Reported By: Eddy Poullet
Reported On: 10/1/2001
For: Version 2.11 Build 1
# 910 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



Resolution Resolution
Fixed Problem on 10/1/2001 in version 2.12 build 1
Image