Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 1/12/2004
For: Version 4.01 Build 1
# 1530 SQL IMPORT TABLE Statement Does Not Parse Delimiters Correctly and Is Not Optional

I've tested the V4 IMPORT TABLE statement with the following SQL and found the following:

1) Delimiter character using the pound sign and the ASCII value doesn't work.

2) The DELIMITER clause seems to be required, not optional as documented in the manual, when the default delimiter character (',') is used in the text file.

import table Imp_table
from 
"C:\Documents and Settings\Ole\My Documents\DBISAM4
TestDB\Imp_text.txt"
/*delimiter #9*/
delimiter ','
with headers



Resolution Resolution
Fixed Problem on 1/14/2004 in version 4.02 build 1
Image