Icon View Incident Report

Serious Serious
Reported By: Malcolm Taylor
Reported On: 12/3/2009
For: Version 2.03 Build 6
# 3112 Using QUOTE CHAR #0 with IMPORT TABLE Statement Does Not Work Properly

In the Manager (unicode but ansi should be the same) I have been doing the following, and it works as expected.

Now delete the records from "ATableCopy" and edit the script to change QUOTE CHAR #34 to #0

Execute the script again .. and I see the correct number of records imported, but all values are NULL.

CREATE TABLE "ATableCopy"
(LIKE "ATable");

SCRIPT ()
BEGIN
  EXECUTE IMMEDIATE 'EXPORT TABLE "ATable"
                     TO "Data.csv"
                     IN STORE "AStore"
                     DELIMITER CHAR #124
                     QUOTE CHAR #34';
  EXECUTE IMMEDIATE 'IMPORT TABLE "ATableCopy"
                     FROM "Data.csv"
                     IN STORE "AStore"
                     DELIMITER CHAR #124
                     QUOTE CHAR #34';
END



Resolution Resolution
Fixed Problem on 12/5/2009 in version 2.03 build 7


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
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