Icon View Incident Report

Serious Serious
Reported By: Arnd Baranowski
Reported On: 10/21/2004
For: Version 4.13 Build 1
# 1883 SQL UPDATE with Sub-Query in WHERE Clause Containing Another WHERE Clause Causes Error

The following generates a SQL Parser error on the "TimeZone > 1". The Parser wants "String, Null etc." and complains that 1 is not of this type.

Update "\Memory\ExportM" Set
bl24 = false
WHERE (Destination in
(Select Destination from "\Memory\ExportM" WHERE TimeZone > 1))

Destination is String
TimeZone is Integer

Resolution Resolution
Fixed Problem on 10/26/2004 in version 4.14 build 1