>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.
Can you show some code as how do you retrieve the data from SQL Server? If you try sqlexec from the command window, what do you get?
Also, there is no SQL Server 2003, are you using SQL Server 2005? And what is the type of the field - text or varchar(max)?
If it's not broken, fix it until it is.
My Blog