View Incident Report

Serious

Reported By: Ricardo Oliveira
Reported On: 12/29/2006
For: Version 4.25 Build 1

# 2221 IF Function Not Returning Correct Results Once NULL Encountered

I have a problem with the following query. Everything works fine until DBISAM finds a record where myField = '' or NULL. From that record on myField will always be null.

UPDATE myTable SET
myField = IF (myField = 'ABC' THEN '123' ELSE myField)

Resolution

Fixed Problem on 12/29/2006 in version 4.25 build 2

Products Affected

DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap