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

DO is a reserved word.