Ah I see but read what I am saying "casting works" or "if you use ADO instead of ODBC". ADO use OLEDB drivers -SQLNCLI10- while SPT use ODBC.
Cetin
>Cetin - this is the message I was referring to. SQL Native Client was definitely not returning memo field data in views filled with SPT. This was in VFP 9 and sql2005 and it had us going crazy for quite a while until someone suggested we switch to the ODBC driver.
>
>>>Does anyone know how to get varchar(max) fields to return data into a memo field using SPT and the SQL Native Client?
>>>
>>>Our framework has two ways of implementing remote views. If we just open the remote view as it is written a M field mapped to VARCHAR(MAX) returns data as expected. If we use SPT on the same view select ( we build it on the fly to implement dynamic view parameters from DBCX ), the memo fields are empty as if fetchmemo were false ( it isn't )
>>>
>>>This is using SQL Native Client for the driver.
>>>
>>>In the same scenario if the connection uses the ODBC driver, the memo data comes in with either method as it should.
>>>
>>>I guess I should not be surprised that in the wonderful world of Microsoft only the older driver works properly with the newer data type <g> but I thought there may be some trick in SPT using SQL Native Client to get this to work properly.
>>>
>>>FWIW casting the varchar(max) in the remote view works with SQL Native Client
>>>
>>>cast(testbed.mnotes as varchar(1000)) as mnotes
>>>
>>>
>>>
>>>TIA
>>
>>Charles,
>>Yes casting works and also if you use ADO instead of ODBC you don't need any casting.
>>Cetin