Hi!

Could you describe your solution for this Problem?

We have to Change the Datatype from text to Varchar(max) bud we are running in the same Problem like you.



>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.