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

I didn't say you must use CAs everywhere. Just when you need them. In that case CA is suitable.
Sometimes pure xBase is much easier and faster than SQL. But imagine after a few years you decide to switch to SQL Server, Oracle or whatever OTHER backend, what will be your choice?
Because I am in process of such transformation (Thanks to our government I still didn't finish my job) I tear my hair off why there was NO CA back in VFP6 when the application was created (and why I didn't knew MORE when we design the application) :-)))))