>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
Gerhard Schmidbauer
URANUS Software GmbH