>>>Interesting that I started with VFP/SQL using SPT and now moving to VFP/SQL using CA. Am I going in the wrong direction? :)
>>
>>No. I think using CA is a good approach and gives more flexibility /ease to write code.
>
>If I may ask you a question, please, on VFP SPT (since you are in this mode of work). When you get a column from SQL Server of type VARCHAR(MAX) using SPT is the type of this column in VFP Char (255) or Memo?

We're supporting SQL 2000, so no varchar(max) fields. I was trying to change one of the tables to use varchar(max), but got an error about default value. Will try anyway.