General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>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.
If you use hungarian notation, even in the absence of a data dictionary you would write a very simple prg to turn a sql statement for sql server into a CA that maps the memo fields. That would provide you insurance against the ultimate deprecation of the TEXT data type in SQL Server.
Hank
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only