Devart Forums

Hi
we have some problem whith the LOAD DATA LOCAL INFILE function. The query doesn't do the good result.

The query is :

LOAD DATA LOCAL INFILE 'C:\delphi7\sources\neoscope2\FILES\IMPORTFILES\temp.txt' INTO TABLE imptempo FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (nom,prenom)

Content of Temp.txt :

"marchand";"mickael"
"poireau";""
"hubert";""


The result in the first field nom is (instead of "marchand"):

delphi7sources
eoscope2FILESIMPORTFILES emp.txt"ma


Config:
Server : MySQL 4.1.9
Developement : Delphi 7 + Mydac 3.55.0.21

But in version 3.00.1.3 this query return the good result.
Also, the command line client and the mysqlimport utility are OK.

Do you reproduce this problem ?

Try to use single '/' instead of double '\

with /
The result in the first field nom is now (instead of "marchand"):

delphi7/sources/neoscope2/FILES/IMPORTFILES/temp.t

We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small sample to demonstrate it and include script to create table.

Thank you for your sample. It did help us very much.
We reproduced your problem and fixed it. This fix will be included in the next MyDAC build. It will be available on next week. Please look forward for announcments at the forum

Thanks for your fix.
But i don't see this problem in the revision history 4.00.1.3 02.09.05.

Is it correct in these version ?

No, the fix will be included to MyDAC 4.00.1.5