Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Not same result when going through OleDb
Message
De
17/04/2006 12:19:11
Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada
 
 
À
17/04/2006 11:44:33
Sergey Berezniker
New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: Not same result when going through OleDb
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01113992
Message ID:
01114080
Vues:
18
>AFAIK, in VFP9 the LIKE 'zzz%' operator is fully optimized if COLLATE of the index is MACHINE.

Then, it's better like that for me as it allows me to use a universal approach and doesn't have to worry about the setting of SET ANSI.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform