>>>>Hi everybody,
>>>>
>>>>Bellow is the CA definition for CA created using CA Builder. When I try to create an instance of it and call CA.CursorFill() the cursor is not created. I don't see what may be wrong here - may be it is a DISTINCT keyword?
>>>>
>>>>Looks like I can not use table aliases - CA gets confused.
>>>
>>>Hi Naomi,
>>>
>>>What does AError() return when CursorFill() fails?
>>>
>>>
>>>hth
>>>-Stefan
>>
>>I didn't have a chance to find it - just fixed the problem. Apparently, you can not use aliases in SelectCmd - CA gets confused.
>>
>
>Interesting, how did your .SelectCmd content look like?
>
>FWIW, the following just worked in a test CA here:
>

>o.SelectCmd = 'Select CU.* From customers CU Left Join invoices INV On INV.cust_id = CU.cust_id Where CU.cust_name Like ?P1'
>

>
>
>
>Regards
>-Stefan

It was

selectCmd = "select distinct DO.OptionID, DD.Option_Desc from DealerOpts DO INNER JOIN DealerOptions DD on DO.OptionID = DD.OptionID"