The MySQL text column should always map to the VFP memo. If it doesn't than it's a problem with MySQL ODBC driver? What version of MySQL ODBC are you using?
>I'm perplexed:
>
>I created a field in MySQL called 'Notes' and made it a 'Text' type field. I added a record, and populated the 'Notes' field of that record with 400 characters.
>
>I then edited the prg filein VFP to add the following two lines to my CURSORSETPROP lines:
>
>cursorsetprop("UseMemoSize",100)
>cursorsetprop("FetchMemo",.T.)
>
>I am assuming from these lines that any 'charcter' field that I bring in that is greater than 100 characters in length will be shown in my browse window in VFP as a memo string. The string, however, shows up as simply characters (400? 256? I didn't count...) in the browse window. I tried changing the MySQL field to a VARCHAR(400) type; the browse window then displayed a 'Gen(eral)' type field. When I double clicked on it, I got an error message saying that the OLE file was either invalid or corrupted.
>
>C
--sb--