>>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 )