>SQLEXEC(nConnHnd , [UPDATE {table} set {BLOB_COLUMN} = ?m.ImageContent WHERE ...])
>works, but , when retrieved back in a remote view, is corrupted.
That exactly what i found, Dorin!
>(I don't know how to determine VFP not to use General field in SPT for >this)
In order to make sure that VFP use a MEMO NOCPTRANS instead of the GENERAL format, I tried the update thru a CursorAdapter-based cursor as well. With a properly mapped field (MEMO NOCPTRANS ). Same Bug on upload.
Curiously enough, i was more successful when running thru a DBC-based remote view. But this application is fully dynamic. Data access is generated on-the-fly from a meta-model and there's no room for dbc in this app(:
>Somewhere between VFP -> ODBC or ODBC -> server >something take place, I >don't know what. But the guy who answer usually on the newsgroup must >know. That's why I told you to send a message there.
>If you provide him an ODBC trace log, he can fix rapidly, if is ODBC driver fault, and release >another usable build.
I'll try. Thank you for your support.
François