>>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