>>I use CursorAdapter. As far as MEMO vs VARCHAR(MAX).
>>1. Didn't I hear that MEMO will be deprecated in new SQL Server versions?
>>2. If I change - via SSMS - the type from VARCHAR(MAX) to MEMO, do I lose all the data?
>>Thank you very much!
>
>There is no MEMO type in SQL Server.
>My idea was to use cursorschema to map varchar(max) field to VFP Memo one.
>
>TEXT TO this.CursorSchema NOSHOW PRETEXT 15
>...
>, FieldThatIsVarcharMAX M
>...
>
I am sorry for my mistake. When I wrote MEMO I meant TEXT.
I didn't know what can "map" VARCHAR(MAX) to VFP Memo. I will have to test it.
I will have to find the Native Client 11 (I don't know if I have it and don't know how to check if I have it).
Thank you!
"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