>>>I added a column to a SQL Server table. The type is VARCHAR(MAX), default is empty string. When I select records from the table in the SSMS, the value is shown in this column. But when I run SQL Select from a VFP 9 application, the resulting cursor has NO value in this column.
>
>With newer ODBC driver, VFP9 returns impossible field type c(0) for varchar max. With original SQL Server ODBC driver VFP returns field type Memo from memory, but then you can't use the other newer field types.
>
>VFPA resolves this bug - see Fix 46 at
http://www.baiyujia.com/vfpdocuments/default.aspAs soon as I posted this question, I realized the problem is with the ODBC driver. I have run into this problem some years ago and forgot about it.
I resolved by casting the value to a text.
Thank you for your suggestion.
"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
