MySQL field outputs to VFP

[tatin]

I literally spent the weekend searching for a solution to this problem.

I have a LONGBLOB field in MySQL which is being populated from a MEMO (Binary) VFP 7.0 field. So when I do an INSERT into MySQL the data in the MEMO (Binary) field finds itself in the MySQL LONGBLOB field correctly.

However, when I do an SQLEXEC(nHandle,"SELECT * mytable",cVFPCursor), the LONGBLOB data gets placed into a GENERAL field in the cVFPCursor.

The Strange thing is that the same thing happens if I use a Remote View to download the data from MySQL. The only difference is that I can Modify the Remote View and change the self determined field type to a MEMO (Binary) and I get the data into it correctly.

The trouble is I need to be able to get a MEMO field in the CURSOR that SQLEXEC dumps the data into.

Please, could someone help me....

 

[ericbrunson]

I think you probably need to find a forum for the language you're writing in. I personally have no idea what you're talking about.