Icon View Incident Report

Serious Serious
Reported By: Paul Coshott
Reported On: 11/10/2017
For: Version 2.26 Build 6
# 4592 Using the LIKE Operator with an Empty String Can Cause an AV

I've suddenly started getting the following error when trying to open (click the Preview tab) in EWB's ide. I updated to the latest EWB and also the latest EDB (trial) and still get the error.

If I enter something into the param value, so {Surname=''} is {Surname='%s%'}, then it opens correctly.

If I have more where clauses, it only takes one param value to be blank and I get the error.

Previously, the following query, when opened in the preview tab, would open correctly with an empty dataset.

(syntax is generic EWB dataset syntax for parameters}

SELECT * FROM Clients
WHERE (FirstName LIKE {FirstName=''}) 
  AND (Surname LIKE {Surname=''})
  AND (Drivers_License LIKE {Drivers_License=''})
  AND (Passport_No LIKE {Passport_No=''})
  AND (DateOfBirth >= DATE{startDOB='1900-1-1'})
  AND (DateOfBirth <= DATE{endDOB='2100-1-1'})
  AND (CompanyID = {CompanyID=0})



Resolution Resolution
Fixed Problem on 11/19/2017 in version 2.26 build 7


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image