View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap