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