View Incident Report

Serious

Reported By: Elevate Software
Reported On: 11/12/2002
For: Version 3.19 Build 1

# 1263 Embedding Multiple Double Quotes Inside of Single Quotes Causes Double Quotes to Be Reduced in SQL

SQL UPDATE statements with embedded double quotes in the data values function incorrectly.

UPDATE TABLE SET FIELD = 'xxx"""yyy'

....will result in xxx""yyy

Resolution

Fixed Problem on 11/13/2002 in version 3.20 build 1

More Support Options