Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I have a need to access VFP data through ODBC from
>>a VB app. The some of the queries need to perform
>>searches as VFP does with SET EXACT OFF. Is there
>>a way of doing this?
>>
>
>Yes; the VFP ODBC driver will accept a SET EXACT setting through SQLExecDirect or SQLExecute - check DRVVFP.HLP for details.
Hey Ed,
Thanks for the reply. It took some digging, but I
found that you have to pass the SET commands to
the ODBC driver separated by semicolons. Using
this method you can also execute multiple queries
for joining subsets, for instance.
A subtlety that I found in creating subsets was
that if you create such a subset, in order to
access the data in the final result set, you have
to use the NextRecordset method because by default
the driver points to the first query that you
perform.
I also found that in addition to the SET EXACT OFF
I needed to issue the SET ANSI OFF to have it
properly interpret comparison of strings of
different lengths.
...kt
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement