>>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!
>
>
>
>LOCAL oTest AS CursorAdapter
>
>oTest = CREATEOBJECT("CursorAdapter")
>oTest.DataSourceType = "ODBC"
>oTest.DataSource = SQLSTRINGCONNECT(.....)
>oTest.BufferModeOverride = 5
>oTest.FetchSize = -1
>oTest.UseCursorSchema = .t.
>oTest.MapBinary = .t.
>oTest.MapVarchar = .t.
>oTest.Alias = "crsTest"
>
>
>WITH oTest.CursorSchema NOSHOW PRETEXT 15
> TheVarcharMaxField M
>ENDWITH
>
>WITH oTest.SelectCmd NOSHOW
> SELECT TheVarcharMaxField FROM YourTable
>ENDWITH
>
>oTest.CursorFill()
>BROWSE NORMAL
>
>
>NOT TESTED!!!
>No errorhandling
Thank you! I will try this but I need to replace the ODBC with the Native Client first.
"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