Icon View Incident Report

Minor Minor
Reported By: Harry de Boer
Reported On: 11/12/2007
For: Version 1.06 Build 1
# 2476 Script Conversion in TEDBScript Component Not Formatting Output Properly

The conversion of old scripts to new style scripts does not deal with new lines correctly (the whitespace that should follow a line in the new script is ignored).

SELECT
extract(month from Datum) AS maand,
SUM(Bedrag) AS bedr
INTO memory tmpJTOV
FROM contracten, contractregels
WHERE extract(year from Datum_van) = 2005
AND contracten.id_contract = contractregels.id_contract
AND Object_of_Artikel = 'O'
AND geannuleerd is Null
GROUP BY maand;

is converted as

SCRIPT ()
BEGIN
  EXECUTE IMMEDIATE 'SELECTextract(month from Datum) AS maand,SUM(Bedrag)
AS bedrINTO memory tmpJTOVFROM contracten, contractregelsWHERE extract(year
from Datum_van) = 2005AND contracten.id_contract =
contractregels.id_contractAND Object_of_Artikel = ''O''AND geannuleerd is
NullGROUP BY maand';



Resolution Resolution
Fixed Problem on 11/12/2007 in version 1.07 build 1


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

Image