Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Building a complex query
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Divers
Thread ID:
00980679
Message ID:
00980715
Vues:
61
Sorry for typo:
cWhere = ""
IF .NOT. EMPTY(concoun)
   concoun = PADR(ALLTRIM(concoun), " ", LEN(globalnew.country))
   cWhere = "globalnew.country == '"+concoun+"'" && for Char Fields
   lAnd   = .t.
ENDIF

IF .NOT. EMPTY(clicoun)
   clicoun = PADR(ALLTRIM(clicoun), " ", LEN(globalnew.acclient))
   cWhere = cWhere + IIF(lAnd," AND ","")  + "globalnew.acclient == '"+clicoun+"'" && for Char Fields
   lAnd   = .t.
ENDIF

IF .NOT. EMPTY(agentcoun)
   agentcoun = PADR(ALLTRIM(agentcoun), " ", LEN(globalnew.aname))
   cWhere = cWhere + IIF(lAnd," AND ","")  + "globalnew.aname == '"+agentcoun+"'" && for Char Fields
   lAnd   = .t.
ENDIF
For all char fields You musr PADR() whith Exe
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform