Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: Binary index incorrect error
Message
De
26/08/2005 17:51:22
 
 
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:
01043794
Message ID:
01044448
Vues:
15
>>you can remember some other boolean functions that it cannot return NULL ?
>
>ISBLANK(), ISALPHA(), e.t.c.

But why those of the team want to check what they are not able
to check, and to create tons of cases where control becomes a bug?

Of course,
with an UDF they have gone to crisis, and therefore they have disabled the check:
ON ERROR
CLEAR
CREATE CURSOR testBinary (aa i NULL)

INDEX ON UDF(AA) TAG TBIN2 BINARY

* a UDF remove the nullable check
INDEX ON SAME(ISNULL(AA)) TAG TBIN1 BINARY

* and then fail here
INSERT INTO testBinary VALUES (1)

PROCEDURE UDF(XX)
RETURN XX=0 OR .NULL.

FUNCTION SAME(X)
RETURN m.x
Of course the message is clear, and says that is TBIN2 that fails!!!!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform