>>>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]