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

Then there is no meaning in ?var. It's intercative or fall back, as you like it.

Inherited from times as one would work with a table from VFP commandline

Gerhard does odd things