>A client has a VFP7 application that passes a string of concatenated field values (?memvars) via EXEC to a SQL SP in another database to Insert or Update a record. Thus far, all of the required fields have been character, numeric or bit. But a requested modification requires that a Memo field be passed. Can a Memo be passed in this way? If not, what's the best way to do this with minimal impact to the code on both ends of the process? I'm away from the office and have minimal resources here so I appreciate your input and help.
A memo could contain either plain char data or anything. If on SQL side datatype is not something like image expecting binary data you can pass directly using ?. ie:
Exec myProc @myParm = ?localcursor.memofield
Cetin