>Yes, I had this error regarding GUID casting to C(36). It seems to sometimes go wrong, especially with NO cursorschema.
>
>With varchar(max) I had the phenomenon it resulted in Char(0) fields (don't confuse with CHR(0)) if the first resultset record was an empty varchar(max). Varchar(max) works fine with the ODBC driver (Driver="SQL Server"), Ii get a memo field there in the resultcursor scheme, independant on the first resultset value in that field.
>
>So it seems with the SQL Native Client driver the automapping of varchar(max) fieldd to the vfp result cursor is working like vfp itself when determining the cursorstructure of resultsets with it's native sql on dbfs: Taking the scheme of the first result record. So maybe the bug regarding varchar(max) is by design. But the chr(0) issue in the conversion of uniqueid to c(36) could also be an error of SQL Native Client.
>
>Driver versions:
>SQL Native Client: 2005.90.3042.00
>SQL Server: 2000.85.1132.00
>
>All in all I second that for now the SQL Server driver is the safer option.
>
>Bye, Olaf.
Yes, we definitely found that we were not seeing memo field data when using remote views against varchar(max) fields when we used the sql native client.
Now always use SQL Server Driver in VFP apps.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.