Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Issue: CAST to V a eval expression fire a error
Message
De
10/04/2005 15:23:25
 
 
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:
01003005
Message ID:
01003247
Vues:
16
>I guess you're right but I still would like to see an example of such index expression from your application.
>

well, i try.

It considers an customer interface, that it allows to define search expressions.
After to have inserted and validated these expressions,
it comes created a normalize function that returns the value of an expression as a string value.
Now, you suppose that these expressions, within a specified parameters set,
can select one primary keys.
Now, in the application you want to find all the expressions that
for the customer parameters set return a specific primary key within the searched range.
With the index of expressions values,
this can to be do faster because you can seek the range of expression
that return the pk range.

The search don't invalidate the customers expressions, but the customer parameters !

In truth the thing is more complex why every expression returns a range of values,
but hopes to have given the idea to you.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform