>Have a table filled with comments. Use varchar for the comments. Something changed in our testing environment, this has been working fine for at least a year. Now a SQL Select to this table the field returned back in VFP in the cursor returns an empty text field. If I copy the SQL select command out of the code, run it at the command prompt I get a memo field with the text that is there which WAS the behavoir before.
>
>Any ideas what to look for.
I assume that you're talking about SQL 2005 and varchar(MAX). You'll get correct result in VFP for varchar(MAX) only with SQL 2000 ODBC driver. With SQL Server Native client empty values will be returned for varchar(MAX). It's VFP bug that is not going to be fixed.
--sb--