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