SQL Passthrough does not map SQL_WLONGVARCHAR fields that
are longer than 255 characters from Microsoft SQL Server to memo field types in
Microsoft has confirmed that this is a bug in the Microsoft
products that are listed at the beginning of this article.
This bug was corrected in the latest service pack for Visual
For additional information about Visual Studio service packs, click
the following article numbers to view the articles in the Microsoft Knowledge
INFO: Visual Studio 6.0 Service Packs, What, Where, Why 194295
HOWTO: Tell That a Visual Studio Service Pack Is Installed
To download the latest Visual Studio service pack, visit the
following Microsoft Web site:
Steps to Reproduce Problem
Run the following from the Command window with
the user having the appropriate permissions.
: You need to provide the actual servername, user identification,
and password for your installation of SQL Server.
nConnection = SQLSTRINGCONNECT("driver=SQL
? SQLEXEC(nConnection, "select * from customers where customerid='CACTU' ;
for xml auto,elements", "cust_xml")
After you run the code, the results appear in a cursor with one
255-character column. Because the size of this particular field is
approximately 351 characters, Visual FoxPro should return the results to a memo