>>>>>>>>The fact is that my entire application is built on SPT and chaning it to CursorAdapter would be impractical (taking too much time). For me the new data type I want to use is DATE type. And I hope that I will still be able to use it with SPT and ODBC. If not, I am in trouble. Thank you.
>>>>>>>>
>>>>>>>
>>>>>>>You can use the Date field type with SPT, ODBC, SQL Server 2008 and the Native SQL Client. It doesn't work with varchar(max) though. You have to use TEXT fields instead.
>>>>>>
>>>>>>Thank you for clarifying. I understand that varchar(max) is much better than TEXT (not sure why though) but will have to live with it.
>>>>>
>>>>>You can not use many operations against Text type, but there are no such limitations for the varchar(max) type.
>>>>
>>>>Do you know what operators you cannot use against Text that you can use against varchar(max)? Do you now what other limitations Text has? Thank you.
>>>
>>>You can not use SUBSTRING function or REPLACE function. There may be many more limitations, these are just quick examples that came to mind.
>>
>>Thank you. It is too bad that MS does even want to enhance the ODBC to make it work with these new types. Real shame.
>
>No, ODBC works with those new types. It is VFP that cannot interpret those new types when you use ODBC.
>PS: It is not limited to varchar(max). You would have problems with other types too like varbinary(max), xml ...
>Cetin

Thank you.