View Incident Report

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

This problem also exists in version 2.11.

Resolution

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap