>>>>Did you apply anything extra for your VFP? I'm running VFP9 latest hotfix.
>>>
>>>Come to think of it, I don't access memo fields using SPT. It can be done, but I can't find the reference (one of which supposedly exists on the UT). The other way is to use a cursoradapter, where you can mapvarchar or mapbinary as needed Because we a) generate all the "normal" views including ones parameterized on the PK and each one of the FK's and b) have some really complex views, we work with remote views, created in xCase, exported to SQL Server format and generated into remote views. We use SPT for quick queries that don't need an entire record.
>>>
>>>Hank
>>
>>That's probably why you don't have problems in your application. In ours we use solely SPT and also updateable views. We don't use CursorAdapter.
>
>This works with OBBC 13:
>
>CAST(mintnote as text) as mintnote
>
>Hank
Right, but it doesn't help us as we don't use such conversion, I think. Finding all places where we would need this change looks like a lot of work.
If it's not broken, fix it until it is.
My Blog