View Incident Report

Serious

Reported By: Mike Williams
Reported On: 10/24/2001
For: Version 3.03 Build 1

# 953 Multiple Consecutive Quotes Not Being Reduced Properly in SQL and Filter String Constants

I'm trying to use a SQL insert statement to add two quotes in a row to a string field. The following 3 queries produce equivalent results:

insert into test2 (test) values ('Here''s a quote');
insert into test2 (test) values ('Here''''s a quote');
insert into test2 (test) values ('Here''''''''''''s a quote');

CREATE TABLE "test2.DAT"
(
"test" CHARACTER(50),
LANGUAGE "English (USA)" SORT "Default Order"
USER MAJOR VERSION 1
);

Comments

Thanks to Mike for the code that fixes the problem also.

Resolution

Fixed Problem on 11/8/2001 in version 3.04 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap