>I'm trying to use [^y]% as a filter parameter to create a view that only returns records begining with y. I learned somewhere that this should be possible. However, i can't seem to make it work.
>Does anybody have an idee what i'm talking about and how to make this work??
>
>thanks.
The way I create paramerized views in VFP is with
?variable, in the view designer, which would generate the expression:
WHERE Field = ?Variable. Then, you have to assign a value to your variable.
If this is fixed (you always want records that start with "y", and no other letter), use a clause like
WHERE left(Field,1) = "y". This may need some tweaking, for optimization. You can also use
WHERE Field = "y", but this only works with SET EXACT OFF.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
