>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