Icon View Incident Report

Serious Serious
Reported By: Mats Berggren
Reported On: 10/10/2007
For: Version 1.05 Build 2
# 2468 IMPORT TABLE Not Working Properly for Unicode Applications

I use ElevateDB Manager (Unicode) version 1.05

In the ElevateDB Manager I create the following simple table. Then I insert one row and export the table to a textfile with the following EXPORT TABLE statement. Then I delete the existing row in the table Test1 and try to import from file with the following IMPORT TABLE statement. When I execute the import I get an error message:

================================================================================
SQL Error (ElevateDB 1.05 Build 1)
================================================================================

ElevateDB Error #904 Error importing the file D:\Delad\NappData\Test1.csv into
the table Test1 (The import file is truncated or incomplete)

CREATE TABLE "Test1" (
"ID" INTEGER NOT NULL ,
"FRNR" INTEGER NOT NULL ,
"ABNR" INTEGER ,
"ARKBILD" VARCHAR(50) COLLATE "SVE_CI"
)

EXPORT TABLE "Test1"
TO 'D:\Delad\NappData\Test1.csv'
DELIMITER CHAR #9
QUOTE CHAR '"'
DATE FORMAT 'yyyy-mm-dd'
TIME FORMAT 'hh:mm:ss n' AM LITERAL 'AM' PM LITERAL 'PM'
DECIMAL CHAR '.'
BOOLEAN TRUE LITERAL 'True' FALSE LITERAL 'False'
INCLUDE HEADERS
MAX ROWS -1

IMPORT TABLE "Test1"
FROM 'D:\Delad\NappData\Test1.csv'
DELIMITER CHAR #9
QUOTE CHAR '"'
DATE FORMAT 'yyyy-mm-dd'
TIME FORMAT 'hh:mm:ss n' AM LITERAL 'AM' PM LITERAL 'PM'
DECIMAL CHAR '.'
BOOLEAN TRUE LITERAL 'True' FALSE LITERAL 'False'
USE HEADERS
MAX ROWS -1



Resolution Resolution
Fixed Problem on 10/22/2007 in version 1.06 build 1


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 VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image