Reported By: Eddy Poullet Reported On: 10/1/2001 For: Version 3.01 Build 1
# 891Cannot 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
CommentsThis problem also exists in version 2.11.
ResolutionFixed Problem on 10/1/2001 in version 3.02 build 1