Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wild card in where clause
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Wild card in where clause
Divers
Thread ID:
00246921
Message ID:
00246921
Vues:
57
Can you use a wildcard in the where clause of a select statement?
if thisform.cToShow = "All"
    lcCatToShow = ""        &&>>> This is where I want a wildcard
   else
    lcCatToShow = thisform.cToShow  && Or a specific one
endif

SELECT a.company, a.conname, a.ab_id ;
	from AddressBook a;
	inner join CatLink on a.ab_id == CatLink.ab_id ;

	where obsolete = .f. ;
	and CatLink.Catagory == lcCatToShow ;

	ORDER by &lcDisplayOrder  ;
	into cursor DisplayNames
I tried the "" and got nothing.

TIA
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform