Thanks Cetin and Ian

That works.

Judging from the number of threads with questions about cursoradapers, more people are looking at them. My upgrade path with my clients is Sequal Server and this will make it a lot easier once I understand it.

Thanks to both
Gaylen


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