>First question, Can you use wildcards in parameterized views and if so, what are the wildcards for the different data types?
>
>Second, How much is performance degraded if I have 15+ paramaters in a view and am using wildcards on all but one or two parameters? I'm trying to do a Query by form for one particular form.
>
>Any thought or pointers to articles on this will be much appreciated!
Wildcards are done by using LIKE in the select statement -- (hint, this means you shouldn't use the VFP view designer for your views - eView works very nicely for this.)
The wildcards for the LIKE clause in a SELECT are "%" for all characters and "_" for a single character - this is ANSI-SQL standard, so it works in all databases.
LIKE only compares character strings. For non-character fields, like date or numeric, some other comparison should be used - e.g. instead of finding dates like "12/%/2000", use
where month(datefield)=?vpnMonth and year(datefield)=?vpnYearHTH
Insanity: Doing the same thing over and over and expecting different results.
