>>>You could include the parameter in the view ( in this case)
>>>
>>>select Table.*, ;
>>> cast ( ?lnYear as Int ) as MyParam;
>>> from ....
>>> where (YEAR( DATEFIELD ) >= ?lnYear )
>>
>>Using this code I get an error "SQL: Column 'lnYear' is not found."
>>
>>Any idea what I do wrong?
>>
>>TIA
>>Gerhard
>
>
>Works fine over here - providing you assign a value to lnyear
>
>

>lnyear = 2000
>select dossier.*, ;
> cast ( ?lnYear as Int ) as MyParam;
> from dossier ;
> where (YEAR( d_custenddate ) >= ?lnYear )
>

The sense of ?Var is to interactiv input the var if not defined?

This will work on WHERE clause only