Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server Driver vs more recent ODBC driver
Message
De
23/11/2018 15:59:14
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Divers
Thread ID:
01663573
Message ID:
01663755
Vues:
39
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform