>>>>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?
OK, but I always define the parameters in code - I never use the popup asking for a value
>This will work on WHERE clause only
Gregory