Reported By: Eddy Poullet Reported On: 10/1/2001 For: Version 2.11 Build 1
# 910Cannot 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
ResolutionFixed Problem on 10/1/2001 in version 2.12 build 1