Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What does this text do?
Message
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
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01348085
Message ID:
01348098
Vues:
15
Mike,

The question mark indicates a parameter (as in a view). However in this case you can drop "?" and result will be the same.
Also it's better to put a field in the WHERE condition on the left.
* If ThisForm.Customer is numeric/integer
    (ThisForm.Customer = 0 or  Ordhead.customerid = ThisForm.Customer)
* If ThisForm.Customer is character (nn is the size of Ordhead.customerid field)
    (ThisForm.Customer == SPACE(nn) or  Ordhead.customerid = ThisForm.Customer) 
>In a SQL select statement. (original code VFP 5) I came across the code below as part of the WHERE clause
>
>(Empty(?ThisForm.Customer) or  ?ThisForm.Customer= Ordhead.customerid)
>
>
>As stated previously, empty is not rushmore optimizable, therefore how do I change this to return the same info. I am rewriting the queries in VFP 9 and wish to get the same results.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform