Icon View Incident Report

Serious Serious
Reported By: Tiago Ameller
Reported On: 1/21/2004
For: Version 4.02 Build 1
# 1551 Using a NOT Operator Around a Large Block of OR Expressions in Live Query Can Cause an AV

Try this query LIVE and dbsys will raise an A.V. In canned mode works fine.

SELECT * FROM "SFCLI030" WHERE  NOT ((UPPER("Nombre") LIKE '%971%') 
OR (UPPER("NombreComercial") LIKE '%971%') OR (UPPER("NIF") LIKE 
'%971%') OR TEXTSEARCH('971*' IN "Comentario")) ORDER BY Codigo  NOCASE

Resolution Resolution
Fixed Problem on 1/24/2004 in version 4.03 build 1