>The CursorAdapter datasource is the connection handle. No problem.
>
>So the only issue you have is identifying your memofields. If you a) have them uniquely identified (e.g., mMyMemo) or have an active data dictionary, use that information to "map" those fields to Memo data type in VFP. And if not, that information is easy enough to pull from your DBC either dynamically or once, the latter into a cTable, cField table you package into your EXE. That information is used to map from the backend to the CA.
>
>Hank
>
I don't understand you. We do use sqlexec for our data manipulations. sqlexec is not used directly but rather something like mysqlexec and we're passing the sql statement to it, say, 'select * from dbo.myTable where someColumn = 123".
The select * may refer to a table having varchar(max) column in it.
If it's not broken, fix it until it is.
My Blog