Juan,
I don't know anything about MyODBC driver but VFP character variable can be up to 16MB in size and even more. The string literal size is limited to 255 characters.
>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 !
--sb--