Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Where does it make sense to use BINARY index option
Message
De
25/08/2005 09:14:21
 
 
À
25/08/2005 09:08:58
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
Divers
Thread ID:
01043681
Message ID:
01043824
Vues:
7
Fabio,

Excellent examples!

Thank you,
Malcolm

>Verify it here
>
>clear
>ON ERROR
>CREATE CURSOR testBinary (aa i NOT NULL)
>INDEX ON EMPTY(aa) TAG bitmap BINARY
>SYS(3054,12)
>
>SELECT * FROM testBinary t1 WHERE EMPTY(aa) INTO ARRAY ZZ
>?
>SELECT * FROM testBinary t1 HAVING EMPTY(aa) INTO ARRAY ZZ
>?
>SELECT * FROM testBinary t1 JOIN testBinary t2 ON EMPTY(t1.aa) AND EMPTY(t2.aa) INTO ARRAY ZZ
>?
>SELECT * FROM testBinary t1 FULL JOIN testBinary t2 ON EMPTY(t1.aa) AND EMPTY(t2.aa) INTO ARRAY ZZ
>
Malcolm Greene
Brooks-Durham
mgreene@bdurham.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform