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?
I've tried using the LIKE operator
(WHERE dmiProv.LastName LIKE 'MILL%') but this is
not optimizable and the query takes between two
and eight minutes over the network. I've also
tried using the '=' operator, but this works like
'==' (WHERE dmiProv.LastName = 'MILL').
Can anyone give me some direction on this problem?
...kt
Suivant
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