>>Newbee with CA here
>>
>>In my selCmd I want to use a parametized query. If I use ?lnxxx it works. If I use thisform.xxx I am prompted to enter the value for xxx. Both ar populated before cursorfill(). Using "native" datasourcetype.
>>
>>
>>local loCursor as CursorAdapter, ;
>> laErrors[1]
>>thisform.xxx = 37000
>>loCursor = createobject('CursorAdapter')
>>with loCursor
>> .Alias = 'cPolicy'
>> .DataSourceType = 'Native'
>>
>> .SelectCmd = " select sif_no,fund_yr from policy where sif_no = ?thisform.xxx "
>>
>> .cursorschema = "SIF_NO I, FUND_YR I "
>>brow
>>
>>
>>
>>Thanks
>>Gaylen
>
>Gaylen,
>I don't know the answer (weird for me too and trying to understand CA myself). Interestingly if you create that in DE and use builder, it works.
>Cetin
I think Ian is right.
toForm = thisform
.SelectCmd = " select sif_no,fund_yr from policy where sif_no = ?toform.xxx "
and it works.
Cetin