Hi Everybody..

I use to work with VFP + MySQL using the MyODBC 2.5 interface, yesterday i installed MyODBC version 3.51 and at the begining my current project seems to run fine, but later i found a problem:

One of my forms uses an editbox control linked to a memo field, when i issue a SELECT command through MyODBC i got the data without problems, but when i try to perform and INSERT statement i got a 1148 error from MyODBC.

I don´t know if i use the best technique: when i have a memo field with more than 256 characters i don´t use the INSERT statement because of the 256 char limitation with VFP variables, so i fill a text file with the data in the memo field and then i issue a LOAD DATA LOCAL INFILE "myfile.txt" through MyODBC using SQLEXEC(). (Is there another way to achieve the same goal?)

I read about the 1148 error and i found that MySQL server comes compiled with the LOCAL DATA option active by default.

With the 2.5 version there is no problem, but i want to work with the new one (3.51) because it´s faster.

Thanks !