View Incident Report

Minor

Reported By: Michael Fullerton
Reported On: 8/24/2009
For: Version 2.02 Build 15

# 3061 Using the h:mm:ss Time Format with the IMPORT TABLE Statement Can Cause an Error

I have a single record file. If I try to import it says the first timestamp field can't be null. But its not null. I think its perhaps due to the empty line at the end of the file so I remove that. Now it says the file is truncated or corrupt. Attempting to import from EDBMgr it says the first date field can't be null. Record is below.

"1","8/24/2009","8/24/2009 8:00","8/24/2009 10:30","218","ACCT
T","Unger  Larry S","w1'-20","ad",,,"12/14/2009",,,,,,True

Comments and Workarounds

The problem was that the h portion of the h:mm:ss time format used during the import process. The workaround is to use the hh:mm:ss time format instead.

Resolution

Fixed Problem on 8/26/2009 in version 2.03 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 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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap