View Incident Report

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap