Icon View Incident Report

Minor Minor
Reported By: Roy Lambert
Reported On: 6/10/2013
For: Version 2.12 Build 2
# 3833 TEDBScript ConvertSQL Method Adding Spaces Incorrectly to CLOB Data

I've just used this facility pretty much for the first time. I used your drag'n'drop a table into an sql window to create INSERT statements for a couple of rows I wanted to change in my config table. Selected the appropriate rows, prefaced them with DELETEs added ; to the end of each line and then used ConvertSQL.

The problem is that the two rows in question have lists in one CLOB column. Drag'n'drop worked fine but ConvertSQL added spaces in front of the lines in the CLOB data.

I tried with Tabsize left as the default and set to 0.

INSERT INTO "Config" VALUES ('ContactStatus',
                  'X',
                  FALSE,
                  '
Placed
Client
CV on file
Sales prospect
Hold
Had CV
Headhunted
Spoken
Archived
Erase
-no calls-',
                  'Contact status',
                  'Special',
                  'Special',
                  'X')!



Resolution Resolution
Fixed Problem on 6/15/2013 in version 2.13 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image