Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL with LIKE clause
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL with LIKE clause
Divers
Thread ID:
00036165
Message ID:
00036165
Vues:
64
I am trying to use a local paramaterized view with a filter that says:

maininf.name LIKE ?m.cname

I created this view using the visual interface and when I run the view an it asks for the parameter I type the following:

"smi%"

the program generates an Invalid Type error, yet when I modify the view and enter smi% into the filter instead of ?m.cname, the program works just fine. If I change the LIKE to an = and use the ?m.cname it also works fine (without using the % sign).

Any ideas of how to fix this?
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Répondre
Fil
Voir

Click here to load this message in the networking platform