Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set filter to not empty()
Message
 
 
À
02/01/2014 11:33:15
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01591204
Message ID:
01591256
Vues:
64
Most likely it'll error out because filter expression is evaluated at the time when record pointer moves. lcSpaces may be out of scope than.

>EMPTY() is not Rushmore optimizable unless you add an INDEX ON EMPTY(myfield). That is a non-discriminating index. If you already have another index on myfield like this... INDEX ON UPPER(myfield) TAG xmyfield
>
>then the following will work.
>
>lcSpaces=space(len(myfield))
>SET FILTER TO UPPER(myfield) # m.lcSpaces
>
>You won't need a new index and it will optimize.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform