>>>>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?
>
>
>Pratically, you cannot use VARCHAR(MAX) in VFP.
>
>SQL Server 2000 ODBC driver return a memo ( correctly ),
>but it doesn't support all sql server 2005/8 news
>
>SQL Server 2005/8 ODBC driver return a varchar(0) ( unusable ), this is a VFP bug.
>
>Microsoft,in BOL, says that text are obsolete and no longer supported in the future, perhaps.
>
>Good luck to all!
This is bad. I suppose the only "practical" approach (if you don't use new types in SQL server 2005/2008) is to go with SQL Server 2000 ODBC. Then you can use VARCHAR(MAX). And the only other type would be nice to have supported is Date type in 2008 but that is not to be. Thank you for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
