Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 10/1/2002
For: Version 3.17 Build 1
# 1234 Trying to Use the SQL REPLACE Function With a Data Column Does Not Work

The following test script returns 'FreddyMan' as Fld1 value, while my intention was 'FreddyTHEMan'.

DROP TABLE IF EXISTS MEMORY Test;
CREATE TABLE MEMORY Test(
Fld1 CHAR(20),
Fld2 CHAR(3)
);

INSERT INTO MEMORY Test VALUES('FreddyTheMan', 'THE');

UPDATE MEMORY Test SET Fld1=REPLACE('The' WITH Fld2 IN Fld1);



Resolution Resolution
Fixed Problem on 10/2/2002 in version 3.18 build 1
Image