>Thanks, Craig, but that did not help. I've googled a lot on this and see that varchar(max) simply doesn't work, not only for FoxPro, but other things as well and MS doesn't seem to be doing anything to change that based on the dates of the posts I've seen.
>
>Ok, I might have to change my varchar(MAX) to old and soon to be deprecated Text fields in SQL. Really don't want to do that!
However we don't know when the Text data type will be deprecated in SQL. It was announced in 2008 but it is still available in SQL 2014. You can use it now and solve the problem at a later point in time when (and if) it really happens. It depends of course on the nature of your application if it's wise to take that risk.
Christian Isberner
Software Consultant