>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.
Hi Lynda,
Passing a memo this way could be problematic for a couple of reasons:
- The size of command line is limited
- Some special characters could cause call to error out
It seems to me that VFP COM object would be better suted to perform this task than EXE.
--sb--