>>Ok, if I do the line:
>>
>>vp_studentRule = [( Student.cid <> 'ZZZZZZ')]
>>
>>in the command window before validating, the DBC validates without error.
>>So, where does this need to be defined, if adding the line to the top of the view PRG is not working?
>>Thanks for your continued help,
>>Amanda
>
>Amanda,
>
>It's something I found out.
>
>Normally view parameters do not have to be defined if you use them with NODATA
>
>There are two exceptions to this - why I don't know
>
>parameters used in
>(1) macro subsitution - a la &?param
>
>(2) parameters used in JOIN
>eg
>
>select ..
> from table1 ;
> join table2 on (table1.fld = table2.fld) and (table1.codeX = ?param)
>...
>
Interesting. Going back to the question - do you see a way to somehow have the default parameter value saved with a view?
It looks like in Amanda's case she needs to remember to set this parameter in Command Window before running validation program. Unless there is a way to do so in Stonefield.
If it's not broken, fix it until it is.
My Blog