>>>>>>The other advantage that you can even change where condition dynamically, which is hard with the view.
>>>>>
>>>>>That is why I LOVE CAs :-) (and there is no need to use View DESIGNER :o))))))
>>>>
>>>>But you may have to use BUILDER <g>
>>>
>>>CA builder is good, but I like VFP8 more than VFP9 one. VFP8 put all in Init event of the CA within TEXT ENDTEXT. After that it is easy to copy and paste the code wherever I want.
>>
>>May I ask you related question? When working with CA, is it required to fill cursor using Select-SQL?
>
>Yes. The SelectCmd is pure SELECT-SQL code, no xBase code allowed here.

It may create some performance issues. If table is big then it happens when Seek/Scan/Insert works faster than Select. Also, in a case of complicated functionality, writing appropriate one-command Select-SQL could become problematic.