Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CFindForm with SQL
Message
De
25/10/2004 09:52:39
 
 
À
24/10/2004 21:53:49
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Database:
MS SQL Server
Divers
Thread ID:
00954162
Message ID:
00954233
Vues:
13
>
>   WHERE
>         Upper(First)=Upper(@First) AND
>         Upper(Last)=Upper(@Last) AND
>         Upper(Address)=Upper(@Address) AND
>         Upper(City)=Upper(@City) AND
>         Upper(State)=Upper(@State) AND
>         Upper(Zip)=Upper(@Zip) AND
>         Upper(Country)=Upper(@Country) AND
>         Upper(Number)=Upper(@Number) AND
>         Upper(Street)=Upper(@Street) AND
>         Upper(Unit)=Upper(@Unit)
>      RETURN(0)
>
I usually wrap the parameter in an IIF(EMPTY(FieldName), .T., [condition]).

Chris.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform