>>>>Use a CursorAdapater class if you need memofields from a dynamic query. It was made for that purpose, and you only need to map certain fields.
>>>>
>>>Not an option for us.
>>
>>And why would that be?
>
>Because in that huge application (which is currently being re-written) there are statements like
>
>=mySQLExec('select * from myTable where ', ...)
>
>MyTable can have varchar(max) columns or varbinary(max) columns or text columns (sometimes one table has both types).
>
>So, what exactly you're proposing that will require minimum changes (say, just a change in mySQLExec procedure)?

Yes: you had the good sense to wrap the sqlexec, so making it into a cursoradapter class that does the same work is easily done. The only question is whether you have metadata available (e.g., you are using hungarian notation; you have a data dictionary; etc. -- assuming you have the VFP tables available, it would be short work to get a table with table and fieldnames available where the VFP side is a memofield). From there it's straight-forward.

Hank