Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1526 Connectivity Error
Message
From
13/04/2000 21:44:12
George Simon
GS Data Technologies, LLC
Cincinnati, Ohio, United States
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00358720
Message ID:
00359614
Views:
8
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
Previous
Reply
Map
View

Click here to load this message in the networking platform