>Hi all,
>
>I have a problem which seems to be widely encountered in using SQL Passthrough with SQL Server: Truncated conversion of VARCHAR fields. Specifically, the VARCHAR fields come over as 255 character memo fields.
>
>I've been using SQL Passthrough a fair bit, but I am relatively new to ADO. I created an ADO recordset of the same data, and it appears that it too truncates the VARCHAR fields at 255 chars. I was hoping that ADO would be a way around this limitation.
>
>Am I missing something? Is there some way to bring over the entire VARCHAR field using SQL Passthrough or ADO? If not, how do people work around this? My system is storing long descriptions in memo fields, and I need to update these descriptions on the web, which uses SQL Server as the backend.
>
>Any thoughts would be appreciated.
>
>David Marlin

David,
What version of VFP are you using? This was suposedly corrected in SP5.

See http://msdn.microsoft.com/vstudio/sp/vs6sp5/vfpfixes.asp.

HTH.