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.comwww.prenia.comWeblog: blogs.prenia.com/cathi