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