Hi Mike,
Thanks for the response. I found what created the problem. The problem occurred when I tried to use a VFP memo field as an input parameter.
This code generates the error:
SELECT cLead
lnResult = SQLEXEC( lnConn, [{CALL usp_lead_insert ( ?leadid, ?leadnum, ?leadnotes)}] )
This code works:
SELECT cLead
lcLeadNotes = ALLTRIM(cLead.leadnotes)
lnResult = SQLEXEC( lnConn, [{CALL usp_lead_insert ( ?leadid, ?leadnum, ?lcLeadNotes)}] )
I will look at Q240137 this evening.
George
George Simon, MCP