>>>>>>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.
>
Technically, I guess you are right
>Inherited from times as one would work with a table from VFP commandline
>
>Gerhard does odd things
Gregory