It won't work in FoxPro because it's a MySQL command, not a FoxPro command.
The FoxPro command line will only accept FoxPro commands, it's not a
replacement for the mysql client.
Being an old Fox-Jockey, I use VFP 6 to move data in and out of MySQL
databases and have not had a problem.
Try using the VFP import wizard. (Ok, so I hate wizards too but I don't feel
like firing up VFP to figure out the command at the moment.) :)
HTH,
Cal
http://www.calevans.com
-----Original Message-----
From: Boblee [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 6:33 AM
To: [EMAIL PROTECTED]
Subject: Maybe its an Odbc error
However, its just strange,
Using the Myslq-front , front end I can sucessfully execute a load data from
infile
this is actual command
LOAD DATA LOCAL INFILE 'D:/cmremote/mysqldata/PROJ.csv' INTO TABLE
cmremote.CURRENT FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES
TERMINATED BY '\n' IGNORE 1 LINES
and it works fine.
however, when I put that exact command in either my VFP (fox pro) command
line, or program using VFP I dont get the data imported into mysql,?
I am thinking since I know the command itself is fine and I can get just
about anthing else working, with VFP - It might have somehting to do with
the setup of MyOdbc
Has anyone had experience working with VFP6.0 and MySql as a back end that
should shed some light on this.
Thank you
Bob Lee
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php